Twing Data
Subscribe
Sign in
Home
Archive
About
Latest
Top
Slash Your Snowflake Spend: The Power of Account Separation
Reduce your Snowflake spend by distributing workloads across multiple accounts with lower-priced editions.
Aug 18
•
Dan Goldin
Share this post
Slash Your Snowflake Spend: The Power of Account Separation
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
Twing Data Update - August, 2024
We've been busy the past few months and wanted to highlight recent Twing Data product updates.
Aug 12
•
Dan Goldin
Share this post
Twing Data Update - August, 2024
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
June 2024
Handling Truncated Insert Queries using Regex and ChatGPT
We used ChatGPT to generate a Regex that we ran through a battery of tests to handle truncated INSERT query text.
Jun 1
•
Dan Goldin
1
Share this post
Handling Truncated Insert Queries using Regex and ChatGPT
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
May 2024
Building a data pipeline using Snowflake primitives
You can get pretty far using Snowflake's core capabilities without needing to fall into the trap of a dedicated data modeling or orchestration tool.
May 3
•
Dan Goldin
2
Share this post
Building a data pipeline using Snowflake primitives
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
April 2024
Building an open data pipeline in 2024
Using Iceberg allows us to pick the optimal "big data" compute environment for the specific requirements we have. There's no need to limit yourself to a…
Apr 26
•
Dan Goldin
10
Share this post
Building an open data pipeline in 2024
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
Embrace the Differences Between Development and Production Environments for Data Engineering
Rather than try to align development and production environments for data engineer we should instead move to a world where SQL is the universal…
Apr 11
•
Dan Goldin
1
Share this post
Embrace the Differences Between Development and Production Environments for Data Engineering
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
March 2024
Tactics for handling high cardinality, high dimensionality, timeseries data
A survey of a few different approaches for large scale data challenges, with examples from the adtech industry.
Mar 26
•
Dan Goldin
1
Share this post
Tactics for handling high cardinality, high dimensionality, timeseries data
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
Identify unused columns in Snowflake and other data warehouses
Identify unused columns in your data warehouse to reduce cost and improve performance. We provide two ways - one using a Snowflake query and the other a…
Mar 14
•
Dan Goldin
1
Share this post
Identify unused columns in Snowflake and other data warehouses
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
To CTE or not to CTE: The Case for Subqueries
CTEs have been getting a lot of attention but subqueries offer distinct advantages when using iterative query writing style.
Mar 1
•
Dan Goldin
2
Share this post
To CTE or not to CTE: The Case for Subqueries
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
February 2024
The evolution of a data stack
This post describes the seven stages a company's data stack goes through as it matures from a startup to a large enterprise.
Feb 22
•
Dan Goldin
2
Share this post
The evolution of a data stack
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
The Curious Case of a Snowflake CTE
Snowflake has an odd behavior when using a HAVING clause within a CTE definition that doesn't exist in other SQL dialects.
Feb 15
•
Dan Goldin
1
Share this post
The Curious Case of a Snowflake CTE
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
October 2023
Introducing Twing Data
A query first approach to modern data challenges
Oct 30, 2023
•
Dan Goldin
2
Share this post
Introducing Twing Data
blog.twingdata.com
Copy link
Facebook
Email
Note
Other
Share
Copy link
Facebook
Email
Note
Other
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts