---json
{
    "description": "This how-to will show you how to use the tabli fill command to  fill all the tables of a schema with generated data.",
    "low_quality_page": "false",
    "page_id": "i8wii619uui2h456ddwwf",
    "title": "How to fill a database relational schema with generated data and tabli"
}
---
====== Tabulify - How to fill a database relational schema with generated data and Tabli ======


===== About =====
This [[..:howto|how-to]] will show you how to use the [[docs:tabli:data:fill|tabli fill]] command to <icon name="mdi:format-color-fill"/> [[docs:op:fill|fill]] all the [[docs:resource:table|tables]] of a [[docs:resource:schema|schema]] with generated data.


===== Steps =====
==== Prerequisites ====
  * You should have ''Tabulify'' installed on your computer.

<btn>
[[howto:getting_started:1_install]]
</btn>

  * You should have followed this ''howto''

<btn>
[[howto:database:tabli_create_table_with_dependencies|How to copy a schema]]
</btn>

==== Schema Listing ====
If you have followed the prerequisites, you should seen now in the [[docs:system:sqlite:howto|Sqlite HowTo connection]] the following tables.

<unit display="none">
<code dos >
tabli data create --with-dependencies store_sales@tpcds tpc_$0@sqlite
</code>
</unit>

<unit>
<code dos>
tabli data list *@sqlite
</code>
<console>
PATH
--------------------------
call_center
catalog_page
catalog_returns
catalog_sales
customer
customer_address
customer_demographics
date_dim
date_insert_stream
dbgen_version
household_demographics
income_band
inventory
item
promotion
reason
s_call_center
s_catalog_order
s_catalog_order_lineitem
s_catalog_page
s_catalog_returns
s_customer
s_customer_address
s_inventory
s_item
s_promotion
s_purchase
s_purchase_lineitem
s_store
s_store_returns
s_warehouse
s_web_order
s_web_order_lineitem
s_web_page
s_web_returns
s_web_site
s_zip_to_gmt
ship_mode
store
store_returns
store_sales
time_dim
tpc_customer
tpc_customer_address
tpc_customer_demographics
tpc_date_dim
tpc_household_demographics
tpc_income_band
tpc_item
tpc_promotion
tpc_store
tpc_store_sales
tpc_time_dim
warehouse
web_page
web_returns
web_sales
web_site
</console>
</unit>