How to Backup Snowflake Data to S3
How to backup a Snowflake database to S3.
How to backup a Snowflake database to S3.
We examine how to bulk-load the contents of a pandas DataFrame to a Snowflake table using the copy command.
We take a closer look at setting up a data pipeline for file-based data sources using Snowflake’s powerful Snowpipes feature.
How to parse nested dictionaries in Snowflake table columns using SQL
Using SQL and dbt, we create a date dimension table using a retail/merchandising calendar known as a 4-5-4 calendar.
How to randomly select rows within a subset or group of your data using SQL
An opinionated introduction to ‘advanced’ SQL for data warehouse platforms, such as Redshift, Snowflake and Teradata, Part 2 of N
An opinionated introduction to query strategies for data warehouse platforms, such as Redshift, Snowflake and Teradata
How to calculate approximations of confidence intervals for proportions & probabilities in SQL
We try to solve a plant production example problem using linear programming with Julia using two different formulations.
We’ll be at JuliaCon 2018 from August 7th to 11th in London to learn more about this exciting language and community. Let us know if you’ll be there - we’d l...
We solve a textbook optimization example involving planning multiple warehouse locations using Julia
A Julia port from Python of the Wedding Table Assignment example from PuLP.
How to backup a Snowflake database to S3.
We examine how to bulk-load the contents of a pandas DataFrame to a Snowflake table using the copy command.
We take a closer look at setting up a data pipeline for file-based data sources using Snowflake’s powerful Snowpipes feature.
Working with clients on migrating their Tableau dashboards from Redshift to Snowflake, I ended up writing this little helper in Python that does much of the ...
In this post, we’ll model a key NFL football stat, Fourth Down Attempts, using Bayesian Modeling and PyMC3.
We examine how to bulk-load the contents of a pandas DataFrame to a Snowflake table using the copy command.
We look at how we can use Powersets, Combinations and Permutations to calculate the number of ways we can split products in an order across multiple warehous...
We explore a few applications of the Dirichlet Multinomial distribution using PyMC3.
We try to solve a plant production example problem using linear programming with Julia using two different formulations.
We solve a textbook optimization example involving planning multiple warehouse locations using Julia
A Julia port from Python of the Wedding Table Assignment example from PuLP.
What We’re Reading - Week of 12/09/2019: articles and posts we enjoyed
What We’re Reading - Week of 12/02/2019: articles and posts we enjoyed
What We’re Reading - Week of 11/25/2019: articles and posts we enjoyed
How to calculate approximations of confidence intervals for proportions & probabilities in Tableau
Working with clients on migrating their Tableau dashboards from Redshift to Snowflake, I ended up writing this little helper in Python that does much of the ...
How to backup a Snowflake database to S3.
Using SQL and dbt, we create a date dimension table using a retail/merchandising calendar known as a 4-5-4 calendar.
In this post, we’ll model a key NFL football stat, Fourth Down Attempts, using Bayesian Modeling and PyMC3.
We explore a few applications of the Dirichlet Multinomial distribution using PyMC3.