Skip to content
Big Data Dave

Big Data Dave

Snowflake, Tableau and Big Data

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

Category: Best Practices

March 28, 2021 Best Practices / Count / Snowflake / SnowSQL

Snowflake & Count: A New SQL Notebook Experience for the Analyst

This almost needs to go unstated, but I write several SQL statements every day in Snowflake. The native Snowflake worksheet

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 21, 2020 Best Practices / Snowflake / SnowSQL

Snowflake: VS Code, SQL Tools and GitHub

VS Code is the preferred IDE for many folks developing code for data and analytics. Now there is an extension

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

September 5, 2020 Best Practices / Governance / Snowflake / SnowSQL / Stored Procedure

Snowflake: Long Running Queries Seek & Destroy

So, you might have some long running queries in your Snowflake account? Let’s say someone is running a recursive cartesian

Continue reading

August 29, 2020 Best Practices / Governance / Snowflake / SnowSQL

Snowflake: 10 Things Every Snowflake Admin Should be Doing to Optimize Credits

Snowflake is architecturally different from almost every traditional database system and cloud data warehouse.  Snowflake has completely separated compute from

Continue reading

July 28, 2020 Best Practices / Snowflake / SnowSQL

Snowflake: Command Not Found: SnowSQL

You have installed SnowSQL on your shiney MacBook and for some reason when you go to CLI like a boss

Continue reading

March 21, 2020 Best Practices / Snowflake / SnowSQL / Stored Procedure

Snowflake: Dynamic Unload Path (Copy Into Location)

Sometimes the need arises to unload data from Snowflake tables and objects into a stage (S3 Bucket, Azure Container or

Continue reading

March 15, 2020 Best Practices / Governance / Snowflake / Tableau

Tableau & Snowflake SnowTel: Snowflake Query Telemetry in a Tableau Workbook

Snowflake ships all Query Telemetry from an account over Data Sharing back to account and system administrators of Snowflake.  I

Continue reading

February 25, 2020 Best Practices / Snowflake / SnowSQL / Stored Procedure

Snowflake: Create Without Use Warehouse

Have you ever wanted to CREATE a warehouse in Snowflake, but not immediately use it?  This can be frustrating default

Continue reading

Posts navigation

1 2 Next Posts»
Blog at WordPress.com.
Big Data Dave
Blog at WordPress.com.
  • Follow Following
    • Big Data Dave
    • Join 44 other followers
    • Already have a WordPress.com account? Log in now.
    • Big Data Dave
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...