How to fill a database relational schema with generated data and tabli

About

This how-to will show you how to use the tabli fill command to fill all the tables of a schema with generated data.

Steps

Prerequisites

  • You should have Tabulify installed on your computer.

Learning Tabulify - Step 1 - Installation

  • You should have followed this howto

How to copy a schema

Schema Listing

If you have followed the prerequisites, you should seen now in the Sqlite HowTo connection the following tables.

tabli data list *@sqlite
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




Related Pages
Undraw Data Processing
How to generate data with the Tabulify Data Generator

A collection of how-to's to get the in and out of the Tabulify Data Generator
Undraw Data Processing
How to copy the data definition of all tables from a star/snowflake schema

This howto will show you how to copy the data definition of all SQL tables from a star/snowflake schema.

Task Runner