Brian F. Johnson, M.S.

😳 Databricks Loads Up on Debt Ahead of IPO Databricks raised $1.8B in fresh debt, bringing total access to over $7B as it gears up for a potential public listing. With strong growth, margins, and cash flow, this looks like classic IPO prep.

1

Great to see the momentum around Qlik and Snowflake. At Gogalex, we’ve delivered custom embedded analytics that leverage both platforms together. With data capacity pricing this enables organizations to scale insights, optimize workloads, and reduce consumption costs. #Qlik #Snowflake #EmbeddedAnalytics #DataStrategy

2

📢 Absolutely — here’s a spotlight on a less well-known but very useful Snowflake Data Lineage feature that often flies under the radar: 🌟 Hidden Gem: SNOWFLAKE.CORE.GET_LINEAGE() — Programmatic Lineage Exploration Demystifying Data Lineage in Snowflake: Know Where Your Data Comes From (and Where It’s Going) In today’s data-driven world, understanding how data moves and how objects relate to one another is essential for building trust, maintaining governance, and debugging efficiently. That’s where data lineage in Snowflake comes into play. 🌐 What Is Data Lineage? Data lineage in Snowflake refers to the ability to track the flow of data from its origin (source) to its destination (target)—for example, from a table to a view. It provides visibility into the relationships between Snowflake objects, giving data teams the insight needed to understand how data is created, transformed, and consumed across the platform. https://lnkd.in/ghqScvnB 🔍 Snowflake Data Lineage: Full Example with GET_LINEAGE() This example demonstrates how to track data movement and object dependencies in Snowflake using tables, views, and the SNOWFLAKE.CORE.GET_LINEAGE() function. -- Create base tables CREATE OR REPLACE TABLE T1 (NAME INT); CREATE OR REPLACE TABLE T2 (NAME INT); -- Insert sample data into T2 INSERT INTO T2 VALUES (10), (20), (30), (40); -- Move data from T2 to T1 using INSERT SELECT INSERT INTO T1 SELECT * FROM T2; -- Create view T2_V that joins T2 and T1 CREATE OR REPLACE VIEW T2_V AS SELECT    T2.NAME,   T1.NAME AS NAME2 FROM    T2 JOIN    T1 ON T2.NAME Interpreting Snowflake Lineage Results SELECT    DISTANCE,   SOURCE_OBJECT_DOMAIN,   SOURCE_OBJECT_DATABASE || '.' || SOURCE_OBJECT_SCHEMA || '.' || SOURCE_OBJECT_NAME ||    '-->' || TARGET_OBJECT_DOMAIN || '-->' ||    TARGET_OBJECT_DATABASE || '.' || TARGET_OBJECT_SCHEMA || '.' || TARGET_OBJECT_NAME AS LINEAGE_FLOW FROM TABLE(   SNOWFLAKE.CORE.GET_LINEAGE('MYDATABASE.PUBLIC.T2', 'TABLE', 'DOWNSTREAM', 3) ); DISTANCE SOURCE TYPE LINEAGE FLOW 1 TABLE MYDATABASE.PUBLIC.T2 ➡️ TABLE ➡️ MYDATABASE.PUBLIC.T3 (CTAS) 1 TABLE MYDATABASE.PUBLIC.T2 ➡️ TABLE ➡️ MYDATABASE.PUBLIC.T1 (INSERT SELECT) 1 TABLE MYDATABASE.PUBLIC.T2 ➡️ VIEW ➡️ MYDATABASE.PUBLIC.T2_V (View referencing T2) 2 TABLE MYDATABASE.PUBLIC.T1 ➡️ VIEW ➡️ MYDATABASE.PUBLIC.T2_V (Same view also references T1) 2 VIEW MYDATABASE.PUBLIC.T2_V ➡️ VIEW ➡️ MYDATABASE.PUBLIC.T3_V (Chained view) 3 VIEW MYDATABASE.PUBLIC.T2_V ➡️ VIEW ➡️ MYDATABASE.PUBLIC.T3_V (Duplicate due to multiple paths)

10

2 Comments

Meet Point’s Investment Data Intelligence Platform—a next-gen IBOR and advanced data warehouse architecture that reconciles multi-custodian portfolios, fuels on-demand and persistent analytics, and delivers customisable, total-wealth reporting. Your data foundation for the investment manager of tomorrow. Faster insights, happier clients, effortless scale. 🔗 Learn more & watch the video: https://pointgroup.io/ #WealthManagement #AssetManagement #FinTech #DataIntelligence #AI

10

"Analytics is evolving. It’s no longer just about reporting on the past. It’s about shaping what happens next. Platforms like SAS Visual Analytics are foundational because they make advanced analytics accessible, collaborative and actionable at scale. This is the baseline. Everything that follows builds on it," writes SAS' Ashley Danahy in the first blog of a new series: http://2.sas.com/6041hHtsh

15

Making the shift from SQL Server to Snowflake? This new white paper breaks down every step of the migration journey, with lessons learned from real-world projects and best practices to help you plan smarter and migrate with confidence. Whether you’re moving a few databases or rethinking your entire analytics infrastructure, this guide will help you avoid common pitfalls and build something your business can actually use. Download the full white paper today. ➡️ https://lnkd.in/gmSBxR9J

7