Search Results

Glossary of Terms associated with databricks ADLS2 - Azure Data Lake Storage Gen2; hierarchical namespace–enabled blob storage used for analytics.autoloader - Databricks feature that incrementally ingests new files from a cloud storage path.autoscaling - auto...

Bookstack Markdown Languages These languages are available to use for bookstack code blocks SELECT * FROM Foo WHERE name = 'bar'; Language Keywords you can use after SQL sql JavaScript javascript, js, node JSON json HTML html Python python, py ...

Social Security Administration's baby names database In this cookbook recipe, you will: Download the full babynames_yob data from the Social Security Administration website.  ingest all the CSV files at once using DuckDB. Create and populate rank and pop...

  Watch my short YouTube video on Getting Started with DuckDB Installing DuckDB is fairly quick and easy since it is a single ~36MB file with no dependencies. Installing the command line in Windows The direct download link for x64 and arm64 is on the duc...

If you are using SQL for ingestion and you want to rename columns PascalCase to snake_case -- PascalCase to snake_case -- , OtherNFLStats AS other_nfl_stats SELECT CONCAT(', ', column_name, ' AS ', LOWER( REGEXP_REPLACE( REGEXP_REPLA...

Author's post on twitter Author's website post Encoding & Comprehension Heuristics Preview First (Survey the Structure) Begin any book or paper with a quick overview. Skim the table of contents, headings, introduction, and summary to grasp the outline befo...