Skip to content
Big Data Dave

Big Data Dave

Snowflake, Tableau and Big Data

  • Home
  • Blog Feed
  • Search
  • About Big Data Dave

Category: JSON

November 4, 2023 Best Practices / JSON / Snowflake / SnowSQL

Snowflake: Dynamic IN() Clause & Session Variables

Have you ever needed to program a dynamic IN() clause in Snowflake and found the process daunting in SQL? It’s

Continue reading

December 24, 2020 Best Practices / Data Architecture / JSON / Snowflake / SnowSQL

Snowflake: Hybrid Relational JSON Tables

Have you ever had a new field or field rename break your ETL pipelines to the Data Warehouse and ultimately

Continue reading

November 15, 2020 Governance / JSON / Snowflake / SnowSQL / Tableau

Snowflake: Visualizing Tasks Hierarchy, Tree, Dependencies in Snowsight

I often get asked for better ways to visualize or interact with task dependencies and hierarchies beyond show tasks. I

Continue reading

October 31, 2020 Best Practices / JSON / Snowflake / SnowSQL

Snowflake: Create Nested JSON from Tables and Views with SQL

Snowflake’s native handling of JSON in both READ and WRITE operations is by far and away my favourite feature. For

Continue reading

Blog at WordPress.com.
  • Subscribe Subscribed
    • Big Data Dave
    • Join 48 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Big Data Dave
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar