How to generate data Just With Sql ?

Data System Architecture

About

data generation with just sql is based on then generation of integer sequence via recursive query

Example: for mysql:

with recursive sequence as (
select 1 as id 
union all
select id + 1 as id from sequence
where id < 10)
select * from sequence





Discover More
Example Date Dimension
Dimensional Data Modeling - Date Dimension

The purpose of a date dimension is to support interpretation of the date. Different areas of the business will have different views of the calendar. A date dimension is critical in supporting such interpretations....



Share this page:
Follow us:
Task Runner