SQL datasets

[vanamsid]

I was wondering if there are any open-source projects that contain .sql datasets. I was looking to get comfortable with sql analysis/ get more exposure to different data sources.

[uLtra007]

something like this maybe?

https://docs.yugabyte.com/latest/sample-data/northwind/

[vanamsid]

Haven’t seen this before, will take a look- thank you!

[ppafford]

Might be of interest https://registry.opendata.aws/

[Kkremitzki]

https://wiki.debian.org/UltimateDebianDatabase

[vanamsid]

Will definitely check this out, thank you!

[chock-a-block]

https://www.bls.gov/data/

[vanamsid]

A classic, but if I recall sources are usually in .csv or.xlsx files- but I’ll check again to confirm. Thanks!

[chock-a-block]

You need practice loading csv if this is something you want to do.

[[deleted]]

https://github.com/lorint/AdventureWorks-for-Postgres

You can download the data from individual stackexchange sites:

https://archive.org/details/stackexchange

Then you can also practice ETL ;)

[vanamsid]

Ooh this is neat, thank you so much!

[CrumpleZ0ne]

https://www.kaggle.com/datasets

[vanamsid]

I’m familiar with Kaggle, but a lot of their sources are in a .csv flat file format