Pinned

1. sqlmesh-lhkpn sqlmesh-lhkpn Public

   SQLMesh untuk proyek senang-senang, bikin gudang data lokal.

   1

2. serverless-sqlglot serverless-sqlglot Public

   Forked from sekuel/serverless-sqlglot

   Python

3. dbt_duckdb_chinook dbt_duckdb_chinook Public

   dbt-duckdb playground using Chinook dataset

   8 2

4. Firebase app remove analysis Firebase app remove analysis

   1

   WITH 

   2

   first_open AS (

   3

       SELECT DATE(TIMESTAMP_MICROS(event_timestamp),"Asia/Jakarta") as first_open_dt, 

   4

              user_pseudo_id

   5

         FROM `firebase-public-project.analytics_153293282.events_*`

5. Generate Date Dimension table in DuckDB Generate Date Dimension table in DuckDB

   1

        WITH generate_date AS (

   2

           SELECT CAST(RANGE AS DATE) AS date_key 

   3

             FROM RANGE(DATE '2009-01-01', DATE '2013-12-31', INTERVAL 1 DAY)

   4

             )

   5

      SELECT date_key AS date_key,

6. GA4 and BigQuery, converting event_p... GA4 and BigQuery, converting event_params as columns and keeping the rest of event_params as an array of structs.

   1

   SELECT event_timestamp,

   2

          user_pseudo_id, 

   3

          (SELECT value.int_value FROM UNNEST(event_params) WHERE key = 'ga_session_id') AS ga_session_id,

   4

          (SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'page_title') AS page_title,

   5

          (ARRAY(SELECT AS STRUCT * FROM UNNEST(event_params) WHERE key NOT IN ('ga_session_id', 'page_title'))) AS rest_of_event_params