Bill Bilbottom

## er-diagram.mermaid

      
              2 files
            
          
              1 fork
            
          
              1 comment
            
          
              3 stars
            
          
                Bilbottom
                / er-diagram.mermaid
            
            
              Last active
              July 1, 2024 11:20
            
              
                Mermaid + DuckDB for generating entity-relationship diagrams
              
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## customers-and-loans.sql
/*
    Mermaid + DuckDB for generating customer hierarchy diagrams

    DuckDB version: 0.10.2

    Bill Wallis, 2024-05-09
*/


select version();

## bank-holidays.sql
/*
    DuckDB for dynamically parsing JSON data from a URL

    DuckDB version: 0.10.2

    Bill Wallis, 2024-05-09
*/


select version();

## duckdb-glob-pattern.sql
/*
    DuckDB's `FROM` statement accepts glob patterns

    DuckDB version: 0.10.2

    Bill Wallis, 2024-05-10
*/


select version();

## values-statement.sql
/*
    The SQL `VALUES` statement (in DuckDB)

    DuckDB version: 0.10.2

    Bill Wallis, 2024-05-21
*/


select version();

## datelist-integers.sql
/*
    Datelist integers for true/false attribute history

    DuckDB version: 0.10.2

    Bill Wallis, 2024-06-19
*/


select version();

## weather-event-metrics.sql
select version();  -- DuckDB v1.0.0


/* https://www.linkedin.com/posts/constantin-lungu-668b8756_sql-bigquery-dataengineering-activity-7212478238265139201-dS4y */

create or replace table weather_alerts (
    city_id    int,
    alert_name varchar,
    valid_from date,
    valid_to   date,
	/*
	Mermaid + DuckDB for generating customer hierarchy diagrams

	DuckDB version: 0.10.2

	Bill Wallis, 2024-05-09
	*/


	select version();
	/*
	DuckDB for dynamically parsing JSON data from a URL

	DuckDB version: 0.10.2

	Bill Wallis, 2024-05-09
	*/


	select version();
	/*
	DuckDB's `FROM` statement accepts glob patterns

	DuckDB version: 0.10.2

	Bill Wallis, 2024-05-10
	*/


	select version();
	/*
	The SQL `VALUES` statement (in DuckDB)

	DuckDB version: 0.10.2

	Bill Wallis, 2024-05-21
	*/


	select version();
	/*
	Datelist integers for true/false attribute history

	DuckDB version: 0.10.2

	Bill Wallis, 2024-06-19
	*/


	select version();
	select version(); -- DuckDB v1.0.0


	/* https://www.linkedin.com/posts/constantin-lungu-668b8756_sql-bigquery-dataengineering-activity-7212478238265139201-dS4y */

	create or replace table weather_alerts (
	city_id int,
	alert_name varchar,
	valid_from date,
	valid_to date,