Founder @ Drilldown | Custom-designed business dashboards for B2B SaaS that deliver insights in one click, eliminating the need for complex spreadsheets in just 60 days.

What once felt simple and under control, now runs on many moving parts...

Marketing channels are disconnected from sales, LTV:CAC ratio is a rough guess, and your churn data is a month old.

‍The data to make sense of it all is scattered across Stripe, Hubspot, and product analytics, leaving your team to manually piece it together.

The result?

A collection of outdated reports that no one fully uses.

You’ve tried to fix it, asking people to update spreadsheets, buying new tools, maybe even hiring a specialist. But nothing sticks. Your own engineers are brilliant, but they’re busy building the product customers pay for.

In your mind, it’s simple: you just want accurate numbers so you can stop second-guessing and make the right calls.

At this stage, you face a choice.

You can continue guessing which free users will convert and which sales activities actually close deals, all while your teams debate why customers churn.

Or, you can choose a path to regaining control. The path where you:

- Increase conversion rates from trial to paid users.
- Attract customers who pay more and stay longer.
- Eliminate data debates between your teams.
- Truly understand why churn happens.
- Slash the time it takes to close deals.

We build the system that delivers these results, turning your scattered data into efficient, repeatable ARR growth.

The first step is a conversation. During a 30-minute call, we talk through your situation and what you're hoping to achieve. We'll be honest about whether we're the right fit to help. Our promise: you'll walk away with a fresh perspective, no strings attached.

Check our website for more info: www.datadrilldown.com

Thomas Varekamp

It took me 2+ years to figure this out.

And I still find ways to optimize every week.

Most B2B SaaS companies overcomplicate their data.

They scrap together some open-source tools + write tons of custom code.

A fun project for the engineer.
A nightmare for the business.

Because as soon as you scale:

→ engineers have other priorities.
→ dashboards break and stay broken.
→ maintenance takes hours every week.

The myth: data tools are expensive.
The truth: you can run a complete stack for <$100 /mo.

An engineer spending 1 hour every month on a data is more expensive than using tools.

So I always recommend to keep it simple: minimal code and managed by a single person.

Here is the toolkit we use to make that happen:

1. Extract Data
  
→ Don't write code, use managed connectors.
Examples: Fivetran, Airbyte, Stitch

2. Store Data

→ Centralize everything in one warehouse.
Examples: BigQuery, Snowflake

3. Transform Data

→ Define your logic once, not inside every dashboard.
Examples: Dataform, dbt Labs

4. Visualize Data

→ The final layer for the business.
Examples: Looker Studio, Power BI, Tableau

You don't need complex engineering for business analytics.

You just need the right tools.

Drilldown | Helping B2B SaaS leaders regain control by turning data into direction.

Landed in Bali last week. 

Mixed feelings on this place so far.

What I like:

I found a spot called Omni, a combined co-working, wellness, and gym.

It's basically a hub to get tons of work done with no distractions:

- solid gym
- top-notch service.
- great, healthy food.
- great co-working space.

Everyone is limited by time and energy. This place lets you really maximize both by having everything in one spot.

Also, prices are about 50% cheaper than in The Netherlands. Big arbitrage.

So, here’s what I don't like about Bali (so far):

1. The traffic is crazy. You literally cannot walk here. No pedestrian paths, just cars and tons of scooters.

2. Weird inequality. The moment you step outside of your nice co-working space, you see run-down buildings, broken roads, and trash. 

People that have been in Bali, any recommendations?

This weekend I’m going to explore the Gili Islands, excited for that one!

This is Mex, a Dutch entrepreneur I met here in Bangkok.

We bumped into each other at a club, and I instantly recognized the Dutch 🇳🇱.

A few days later we met for coffee, and that’s when he told me his story.

It all started years ago with Minecraft.

In Minecraft, you can create custom servers, basically private worlds with your own rules. 

Mex originally built one just for his friends, but after a while opened it to the public. The server was so good that people kept joining.

For the first 4 years it was purely a passion project. 

But as the community grew, Mex figured out how to turn this into a business.  

He began offering:

- custom game modes.
- memberships with extra privileges.
- custom skins for players to show off.

The model worked. The server grew steadily at around 20% per year. Then, 2 major events caused an explosion:

1. The pandemic
  
With everyone stuck at home, growth shot up to 100% year-over-year.
  
2. The Minecraft Movie
  
Its release brought in a whole new wave of players.

He scaled up, built a team, and hired an operator to manage the day-to-day.

After a while, he acquired another Minecraft server from a competitor (he told me they finalized the deal in a McDonald's lol)

Now he lives in Bangkok and runs the business remotely.

This is why I love talking to other entrepreneurs. 

You find out about businesses you didn’t even know were a thing.

A dashboard full of metrics means nothing if no one knows what they mean.

At many B2B SaaS companies we work with, this is common:

→ data is stored in some spreadsheets.
→ definitions are not 100% clear.
→ people don’t use the data.

The result: another data projects fails.

We solve this by creating a Metrics Dictionary.

It’s a simple Google Sheets that makes sure we all know what each metric means.

(this makes working with data a lot easier) 

Here’s what we include:

1. unit → what it's measured in
2. filters → how to slice the data
3. calculation → how it's calculated
4. department → who cares / uses it
5. metric owner →who is accountable
6. refresh rate → how often it updates
7. description → what the metric means
8. data source →where the data comes from

I included the template we use in the comments.

Copy it, tweak it, use it.

Good luck!

I'm launching a Youtube channel.

In the last 3 years, I’ve helped 20+ B2B SaaS companies build their data systems and create content about it.

Linkedin is great, but it's hard to show how to actually fix a broken ARR calculation in a 60-second clip.

Youtube allows me to go much deeper.

The goal is the same: help B2B SaaS companies regain control by turning their data into direction.

Topics:

- how to use data for ARR growth.
- how to align your team using data.
- how to operationalize B2B SaaS metrics.
- how to analyze your B2B SaaS business.

Basically everything a B2B SaaS leader needs to build a data-driven business.

The first video is live: https://lnkd.in/egPNPSs5

I show the exact data intelligence system we set up for most of our clients.

The plan: upload every week.

Check it out and let me know what you think!

The past 12 months were pretty stressful.

I’ve been in Asia for 2 months now, thinking a lot about what I actually want from work and life.

My goal with business has always been simple: work when I want, on projects I care about. 

Being here made me realize I’ve more or less reached that point. 

The money isn’t endless, but it’s enough for now, and I don’t need much to enjoy my life. I know being able to say that is a privilege, and I’m really grateful for it.

That made me ask: if I could design a day I’d never get bored of, what would it look like?

(still working on the answer)

Back in the Netherlands I was always in my head about the future, next milestone, next project, skipping fun because “work had to be done.” 

Here, I’m more in the moment. 

Most days I feel relaxed, rested, and creative. I follow more of what I 'feel' like doing instead of what I think I 'must' do.

It’s freeing, and it’s brought up a lot of emotions I’d pushed away. I keep having these random moments of: “Wow, life is actually pretty nice,” lol.

Not sure why I’m sharing this, just felt right.

Maybe it’ll resonate with someone.

Enjoy your weekend.

10 dashboards we’ve built for GTM teams to fix deal pipelines, missed targets, and slow leads.

Over the past few years, we’ve built many custom dashboards for B2B SaaS companies in the $2M–$10M ARR range. 

Below are 10 dashboards we have built for marketing & sales teams to make better decisions:

1. Deals Pipeline
2. Lead Lifecycle
3. Sales Rep Overview
4. Sales Funnel
5. Campaign Performance
6. Sales Overview
7. Target Account Overview
8. Advertisement Performance
9. Website Insights
10. Lead Journey

Scroll to see what each dashboard looks like ↓

Marketing__Sales_Dashboard_Showcase

I fixed a $3.2M ARR B2B SaaS's broken data system

(here’s how)

There is a dangerous transition for B2B SaaS companies around $2M ARR.

In the early days, data is a "favor."

You ask an engineer to pull a quick CSV. They write some code. You get the data.

But as the business grows, that method breaks:

- volume gets bigger.
- questions get harder.
- data is more scattered.

You move from needing a quick export to needing insights on daily basis.

And the engineer who used to run those scripts?

- they are not specialized in analytics.
- they are busy building the product.
- or worse: they left the company.

This creates a massive bottleneck.

And was exactly the case for a $3.2M ARR B2B SaaS I worked with last year. 

The CEO was waiting days for basic insights, and the data pipelines were impossible to maintain.

You can’t lead a company if your data is outdated or incorrect.

I just uploaded a video of how I completely overhauled the data infrastructure for a $3.2M ARR B2B SaaS.

In my new video on Youtube, I break down:

- the specific 15 dashboards I built.
- how I reduced data processing time by 98%. 
- how I aligned the teams on the right metrics. 
- how to drill from ARR to customer details in 2 clicks.

Check it here: https://lnkd.in/eAEps9T7

Our 5-dashboard system that gives B2B SaaS teams 80% of the insights they need.

Many B2B SaaS use data in:

1. spreadsheets
2. some pdf slides
3. a handful of dashboards

But this spread-out approach makes it hard to pinpoint exactly what’s driving growth, or what’s causing churn.

We fix this by building a 5-dashboard system.

It's designed for one purpose: give you complete visibility across everything that leads to ARR:

1. The ‘What’ (Management Overview)

Your high-level Command Center. It's the executive summary of all your key subscription metrics

2. The ‘Why’ (Revenue Overview)

The deep dive on your revenue. The ARR waterfall chart is the most important part. It shows you precisely what's driving ARR change.

3. & 4. The ‘Where’ (Country and Industry Overview)

This is how you validate your GTM strategy. You drill down into a specific segment and see its exact performance.

5. The ‘Who’ (Account View)

The 360-degree view of a single customer. You see their entire MRR history , sales activity, health, and user activity, all in one place.

You can drill down from your top-level ARR number... to the 'Agriculture' industry that's underperforming... all the way down to the specific customer who left.

Leading to:

→ more confident decisions. 
→ better team collaboration.
→ fewer data discussions. 

I put these 5 dashboards in the document below.

Check 'em ↓

The 5 dashboards that cover 80% of the insights (B2B SaaS)

One thing I’ve loved about Bangkok is how easy it is for founders and remote workers to meet people.

There are events almost every single day.

You can literally go to an event on a Tuesday afternoon and meet 10+ people all working on interesting projects.

My favorite example: there’s a weekly co-working meetup hosted at IKEA.

Sounds random, but it’s pretty cool. About 10 people of show up every time. 

We work together, share ideas, and just get to know each other.

I’ve joined twice since arriving, and every time I leave with a couple of new connections and fresh perspectives.

If you are a remote founder / worker, you can find a ton of these events on the Meetup app. 

Highly recommend!

At some point, data starts living in too many places.

That’s when even simple questions like “What’s our churn?...” become surprisingly hard to answer.

Teams pull numbers from different systems, rebuild metrics in spreadsheets, and show up to meetings with dashboards that don’t match.

The result? 

Decisions made on bad data.

At this stage, aligning your data stack becomes essential. But knowing where to start isn’t always obvious.

So here’s the 3-layer data stack we frequently work with:

𝟭. 𝗗𝗮𝘁𝗮 𝗦𝗼𝘂𝗿𝗰𝗲𝘀
Where raw data lives across your business.

→ PostgreSQL:  product usage and event data.
→ Stripe: tracks subscriptions and billing activity.
→ HubSpot: contains commercial customer data.
→ Intercom: logs support tickets to capture feedback.
→ Google Analytics: measures website engagement.

𝟮. 𝗗𝗮𝘁𝗮 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻
Moves, syncs, and activates data across tools.

→ Weld: centralizes data from all sources.
→ Twilio Segment: sends events across apps.
→ Hightouch: pushes insights back into business tools.

𝟯. 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀
Where raw data becomes actionable insight.

→ BigQuery: storage for all company data.
→ Dataform: models data into analysis-ready tables.
→ CompanyEnrich: data enrichment for segmentation.
→ Looker Studio: visualizes metrics for the team.
→ Python / Sheets: enables deep dives and prototyping.

If you're feeling the pain of inconsistent metrics or messy reporting, this structure might show you exactly what's missing.

And possibly solve the problem you've been trying to fix with spreadsheets.

It took levelworks 12 hours every month just to get accurate insights.

(this is Tim from levelworks, check out the video 👇)

This is a classic scaling problem: the most important data lives in manually updated spreadsheets. 

It’s hard to grow when you’re spending all your time just trying to get basic numbers right.

We stepped in and built them a real data foundation.

The result? 

In Tim’s words: “It basically saves us 2 to 3 hours a week.”

More importantly, the team’s conversations are now deeper, more strategic, and lead to higher-quality decisions.

And that’s the point: not pretty charts, but time saved and better decision-making.

Better data → better decisions → better business.

What got you to $2M ARR won't get you to $10M ARR.

Scaling from $0 → $2M is mainly about gut feel.

You're a small team. You're all in the same room. You're 100% focused on finding product-market fit. 

Making decisions on intuition works.

Scaling from $2M → $10M is about systems.

It's not that your gut feel is wrong. 

The problem is that it's not scalable.

You can't be in every sales call, every marketing meeting, and every product debate anymore. 

To scale, your team needs to make their own decisions.

That requires a better data system. 

One that 𝗮𝗹𝗶𝗴𝗻𝘀 everyone on what's important (dashboards) and 𝗲𝗻𝗮𝗯𝗹𝗲𝘀 them to find what's working (analytics).

We identified 𝟲 𝘀𝗽𝗲𝗰𝗶𝗳𝗶𝗰 𝘀𝗶𝗴𝗻𝘀 that tell you your current data stack is breaking.

Check the carousel below to see if you recognize them ↓

6 Signs It's Time to Upgrade Your Data System

6 Dashboards we’ve built for a B2B SaaS to give them end-to-end visibility. 

At Drilldown, we help B2B SaaS leaders regain control by turning data into direction. 

Below are 6 dashboards we built to help their Management, RevOps, Sales, and Customer teams make better decisions:

1. Management Overview
Single overview of the business.

2. RevOps 
Understand how revenue is generated.

3. Account Overview
All account-level info in one spot.

4. Self-Serve Funnel
How users move through the self-serve funnel.

5. Sales Deals Pipeline
Complete view of all deals.

6. Account Health Overview
Spot churn risks & growth opportunities.

Swipe to see them ↓

6 B2B SaaS Dashboards for End-to-End Visibility

Ecochain was struggling with a loss of control.

This is a classic growth problem: their most important data was not readily available.

It’s hard to lead a company when you don’t have a clear picture of what's happening.

We stepped in and built the dashboards + data infrastructure they needed.

The result?

As the CEO Frans-Willem put it:

"The moment I realized it was working was when we could compare the previous results with the current results and see the trends."

They now have the ability to show the results in a better way to the board and can see where they really have the challenges... and to get it resolved.

And that’s the point of data: not dashboards or nice charts. 

But improved understanding, control, and ultimately, better decisions.

The reason you have 20+ unused dashboards? Big chance you skipped some steps.

Here’s what happens:

- you needs insights. 
- you buy a BI tool. 
- you tell an engineer to "build dashboards"

A month later, there are 20+ outdated reports nobody uses.

If this is the case, you probably skipped some foundational work.

Here's the full 5-step system we use to build useful & accurate dashboards 👇

1. Choose metrics

Answer:

- what are your goals? 
- what KPIs track it?
- what are the metrics driving the KPIs? 

This helps to focus on the essentials. 

2. Create a metrics dictionary 

- write down what "ARR" means. 
- what's the calculation? 
- what's the data source? 

This document ends discussions about data. 

3. Extract, Transform & Load (ETL)  

This is the "lean" data stack we recommend for almost everyone:

- extraction: Fivetran / Airbyte / Weld
- warehouse: BigQuery
- transformation: Dataform
- visualization: Looker Studio

You don't need big, complex stack. This setup is cheap, scalable, and powerful.

4. Build dashboards 

- take your metrics dictionary
- start building charts for the metrics
- ask feedback from users

5. Integrate in daily work 

Data means nothing if no trust it.

- give every metric an owner.
- use the dashboard in your meetings.
- review your metrics definitions every quarter.

This is how you go from random dashboards to a data intelligence system that helps everyone.

'How seriously should we take our data?'

Usually, founders know they have a problem. They spend too much time in spreadsheets. They know it's messy.

But they don't know if it's the right time to fix it.

Here is my rule of thumb:

𝗣𝗵𝗮𝘀𝗲 𝟭: $𝟬 - $𝟮𝗠 𝗔𝗥𝗥
Don't invest too much in analytics.

Your Stripe dashboard + spreadsheet is fine.
You are just trying stuff out. 
No need to optimize yet.

𝗣𝗵𝗮𝘀𝗲 𝟮: $𝟮𝗠+ 𝗔𝗥𝗥
This is the tipping point.

You have product-market fit. 
You probably have +30 team members.
You aren't running the day-to-day anymore.

But most importantly: you have a new management team.

These people don't have the historical founders knowledge you have.

When they join, the first thing they usually ask is: "Where do we stand? What are the metrics?"

That's when it's time to invest in better data.

If you want them to lead, you have to give them the data to run the business.

Here's how Ecochain finally got insights they can trust.

Ecochain helps businesses measure their environmental impact.

After setting ambitious growth targets, they faced challenges with data:

→ data scattered across different systems.
→ arguing about which numbers were right.
→ manually exporting data for every report.

You can't grow efficiently when you don’t have the right insights.

So we build their data foundation:

1. Start with a workshop (not a dashboard)

We aligned their teams on the right metrics to track (Trial Users, Conversion Rate, Churn).

2. Automated the data flow

We connected all their key tools (Stripe, Mixpanel, HubSpot) into a central data warehouse. 

This stopped manual exports.

3. Built dashboards

Once the foundation was set up, we built the dashboards. 

Now the data is updated every day and easy to work with.

The result?

→ teams aligned on one set of numbers.
→ faster access to custom data insights.
→ hours saved every week.

Check out the full case study 👇

Case Study Ecochain

A dashboard that takes 10 minutes to load is pretty much worthless.

Nobody will use it. 

This was the reality for Rentman after raising $22M.

They were ready to scale, but their data setup was holding them back:

→ dashboards took 10+ min to load.
→ data was scattered across many tools.
→ teams struggled to use the messy data.

So we came in to rebuild their infrastructure from the ground up.

Here is the 3-step process we used:

1. The deep clean

We worked with their CTO to overhaul BigQuery. We split "Raw Data" from "Production Data" to ensure stability and speed.

2. Smart data orchestration

We set up tools to transform the data automatically. No more manually typing numbers in spreadsheets.

3. Actionable dashboards

We connected all their data points (like NPS & Subscriptions) into single views. Then built fast-loading dashboards for the teams to use.

Now the data is live, reliable, and accessible every day.

The results:

→ instant data visibility.
→ marketing, Sales, and CS aligned.
→ No more waiting 10 minutes for insights.

Check out the full breakdown in the slides below ↓

Case Study Rentman

We recently built a data intelligence system for Expandi, a LinkedIn automation platform doing $10M ARR.

The challenge: 

They had BigQuery and dashboards, but teams were misaligned, with no central place to find all data insights.

We started with a workshop to agree on the top priorities.

Then we rebuilt their data foundations from the ground up:

→ enhanced customer data (30% to 90% coverage).
→ connected user behavior to company metrics.
→ implemented data checks with Slack alerts.
→ cleaned and centralized all data sources.
→ built dedicated datasets for the teams.
→ deployed 10 production dashboards.

The result: 

1. hours saved to focus on strategy instead of data.
2. better alignment between teams.
3. more efficient meetings.

Very happy how this one turned out.

Check the full case study below ↓

Case Study Expandi ($10M ARR)

Snowflake

Principal Solutions Architect

Senior Solutions Architect

Qlik

Principal PreSales Solutions Architect - Analytics / Business Intelligence

I work closely with sales teams (both local & international) to provide product demonstrations, web and windows based art of the possible proof of concepts and most importantly understanding and solving real world business problems using data and analytics. Major part of this role is to be able to understand business problems that the clients are experiencing and to solve their problems with creative & innovative solutions by using business intelligence/visualizations & data analysis techniques. Final challenge is to effectively demonstrate these solutions to both technical & executive teams to have their buy in. 

Best part of this role is to have the opportunity to work with large enterprise customers from wide variety of business verticals and to be able to solve their problems using data by showing them insights that they have never seen before and seeing the excitement that generates  .

Senior PreSales Solutions Architect - Business Intelligence

Helping commercial and large enterprise level organizations achieve strategic insights about their businesses by using the latest technologies in business intelligence and visual analytics. Proving presales support by software demonstrations, technical deep dives and designing BI proof of concept solutions which allow businesses to analyze and discover trends and hidden insights within their data by blending data from disparate sources.

Enterprise PreSales Solutions Architect

Metafile Information Systems, Inc.

Director of Presales Engineering

As a solutions architect specialized in document management, imaging & workflow, I was responsible for sales support as well as designing and implementing ECM/workflow solutions to mid to large size companies integrating automated document management systems with various ERP solutions such as Dynamics (GP, AX, Nav, SL), Oracle, SAP, Sage, Lawson & etc. 

As part of this role I worked closely with our internal sales team and customers who were primarily managers & executives in HR, AP, AR, Marketing, Sales, Finance departments to understand their business processes and  develop an automated Workflow/Imaging/Content Management system that will meet their goals and increase the productivity.
support.

I also created numerous private and public demo assets that were used within the presales teams to increase sales.

Sr. Pre-Sales Solutions Architect 

Supported number of sales teams with technical demonstrations, RFP/RFI responses & technical proof of concepts for creating workflow/approval automation systems in wide variety of departmental solutions such as Sales, Marketing, HR & etc.

Supprted and was the lead solutions architect over 120 new new accounts.

Pre-sales Solutions Architect

As a developer I created ready to deploy AP document management/workflow solutions integrated directly with Microsoft GP, SL ERP systems as well as NetSuite.

These preconfigured solutions saved both time and money in terms of customer solution deployments by eliminating a lot of technical and manual processes as well as replacing API based integration techniques to automatically create transactions in these ERP systems.

Skills utilized for this role: 

Integration Technologies: T-SQL procedures, SOAP/REST web services, Business Object APIs, XML & Flat file transfers. 

Technical writing: Creating technical documentation including project implementation plans, system/workflow diagrams, statements of work, PowerPoint presentations.

Database: Extensive experience with Ms SQL Server database design and administration. Also proficient with Sybase as well.
 
Programming: VB.NET / ASP.Net / VB6, Java & Javascript. Creating custom applications ranging from data conversion tools to 3rd party integration projects.

Developer/Systems Integrator

I was responsible for implementing, configuring solutions on customer sites. This required extensive technical skills including database systems, SQL, VB programming and various Ms Windows administrative functions.

As part of this role, I was also tasked with providing custom training classes to customers as well as creating support & help documentation specific to their implemented solutions.

Technical Lead

Cloud, Data, Analytics & BI expert experienced in helping organizations gain positive business outcomes through the use of modern analytics. Pre-sales architect with over 18 years of experience assisting software sales in large enterprise sales cycles by creating innovative demos, developing prototype applications and creating solutions to address complex data related challenges in the field of business intelligence(BI) & Big data analytic & business process automation, imaging and workflow.

Nick Akincilar

For anyone questioning Snowflake’s #ML power — after Coinbase, PayPal is now showcasing how our #distributed #Snowpark ML training with #XGBoost, #FeatureStore, #ModelRegistry and batch inferencing can scale to predict merchant fees across hundreds of millions of credit card transactions.

If you rewind back 33mins, you can see #AI_SQL for product damage image detection, damage summary as well as online feature store and real time online store recommendation ML models in action.

WATCH PAYPAL BUILD KEYNOTE SEGMENT HERE
https://lnkd.in/eSxk2Mga

Principal Architect | GenAI | Data Strategist | Cloud | Tech Writer

Snowflake Horizon #Iceberg Rest Catalog(IRC) is now in Public Preview. You now have a single catalog (one set of users, roles, authentication) that governs both standard & iceberg tables.  

This allows any 3rd party Query Engine capable of connecting to catalogs using IRC Rest endpoints to authenticate & query Snowflake managed Iceberg tables directly.

Docs:
https://lnkd.in/eq7ipKxh

Blog & Tutorials 
https://lnkd.in/eud8jgwq


Why Snowflake supporting IRC or IRC in general is important?

SECURITY:
- External engines only need a REST endpoint & authentication token. #Snowflake IRC supports Enterprise authentication options such as External Oauth, Key-Pair Authentication, Programmatic Access Token (PAT).  Provider catalog does the authorization & RBAC. 

- Credential vending: This means engine never needs to access the root of the underlying object store where the files reside. Using short-lived credentials reduces the risk of leaks and are intentionally down-scoped to the minimum permissions necessary (e.g., read/write only) for the exact files (not the root or folders) that the query needs to access.  This avoids being forced to grant permanent full access to your iceberg table storage bucket root folder that has data for ALL tables just to be able to share ONE table.

- Private Link support for #AWS and #Azure (#GCP coming soon)

GOVERNANCE & MANAGEMENT:
- One catalog for both standard & iceberg tables, One set of users, One set of roles & RBAC means consistent governance. Allows you to extend Snowflake Horizon RBAC (identities/roles) beyond your Snowflake environment with other engines.

BETTER COST & PERFORMANCE:
Since the engines & catalogs communicate through standard #OSS REST protocol, catalogs automatically deliver required #metadata as the engine traverses the catalog.

This means a 3rd party engine DOES NOT NEED:
1. Additional connectivity layer using JDBC to the provider platform
2. to run slew of SQL queries each time(SELECT databases, SELECT tables, SELECT columns) prior to running any query against iceberg tables using this JDBC connection (slow & inefficient)
3. Use providers compute to execute these catalog queries (extra cost for provider)

EASE OF USE:
Since the only thing needed is the catalog rest endpoint + an access token, it makes things extremely simple both for the provider as well as the 3rd party engine.
 
As most other popular query engines & platforms such as #Fabric, #BigQuery, #Spark, #Trino, #EMR, #DuckDB & etc. have built-in support to leverage IRC catalogs to query iceberg tables, this allows these engines to securely & easily leverage data managed by Snowflake. 

One notable exception is #databricks. It shares its internal tables via IRC(makes it easy for others to read if data is in Unity), but won't allow their users to connect to other iceberg catalogs via IRC by forcing a complex, difficult & insecure workaround. (Makes it difficult to read if data is Not in Unity)

A very common question I get is, 'Why choose Cortex AI Analyst & Snowflake Intelligence over other solutions?' The simple answer: #ACCURACY & #SPEED! 

When leveraging #AI with your data, accuracy is king. Snowflake invests thousands of engineering hours to ensure our solutions are the most accurate and fastest on the market, so you don't have to - and can simply skip the struggle.

This dedication translates to faster time-to-value for our customers. They're building production-ready, AI-driven #data applications with the necessary accuracy, #security, #governance, and #scalability to empower both the #business and #consumers.

Check out this deep-dive from our engineering team that explains just one of the key ways we make Cortex Analyst Service a superior, production-ready Text-2-SQL solution. (Thanks, Jonathan Regenstein, for sharing this gem!)

https://lnkd.in/ep5fQFA6

Snowflake crushing #price, #performance & #TCO. Pricing is just out for the new #Interactive Warehouses and it is 40% cheaper than Gen1 & 55% cheaper than Gen2 compute at only 0.6 credits per hour while delivering 3X to 4X faster performance & throughput required for embedded in-product #analytics.

These multi-tenant in-product workloads require #high_concurrency & #low_latency queries that are typically highly selective, filtering #data based on such columns such as as #tenant_id or #customer_id.

Link to our pricing sheet with the new pricing for interactive analytcis. 
https://lnkd.in/ezr9CPMP

Just tested the new Snowflake #Interactive #Analytics feature, and the results are genuinely blowing the roof off the industry standard for #high_concurrency & #low_latency workloads!

This is a massive leap forward for building embedded analytics in customer-facing portals and products.

I immediately put it to the test with a heavy workload using a single XS instance of each with no multi-cluster option: 
- 1 billion-row Fact table with two dimensional joins (2,500 rows stores and 10,000 rows products).

The performance uplift is massive:

- 2.6X faster than the already incredibly quick Gen2 XS warehouse.
- 3.5X faster than the Gen1 XS warehouse.

THESE NUMBERS ARE JUST FOR 1 XS. If I had multiples running in parallel, it would be ton more but my laptop can't handle the volume.

Why This Matters:
Gen1 and Gen2 warehouses were already leading the pack for speed and concurrency, often only rivaled by expensive in-memory solutions. 

But with these new speeds, the need for costly, third-party low-latency point solutions for in-product and customer-facing analytics is effectively gone.

This new combo can easily run thousands of sub-second queries, finally making Snowflake the single, scalable source of truth for all your enterprise and embedded analytics needs.

Will share the dataset, queries & the Apache Jmeter test template soon.

#Snowflake #InteractiveAnalytics #DataWarehousing #EmbeddedAnalytics #LowLatency

Link to my original #Interactive #Analytics product announcement
https://lnkd.in/eVDTcHuw

taplio

The Battle

Thomas Varekamp

Nick Akincilar

Followers

Posts

Engagements

Likes

Performance ScoreThomas Varekamp's LinkedIn Performance

Performance ScoreNick Akincilar's LinkedIn Performance

Ready to grow your LinkedIn presence?

taplio

The Battle

Thomas Varekamp

Nick Akincilar

Followers

Posts

Engagements

Likes

Performance Score.css-goub6s{font-size:var(--chakra-fontSizes-md);font-weight:500;color:var(--chakra-colors-gray-600);display:block;margin-top:var(--chakra-space-1);}Thomas Varekamp's LinkedIn Performance

Performance ScoreNick Akincilar's LinkedIn Performance

Ready to grow your LinkedIn presence?

Performance ScoreThomas Varekamp's LinkedIn Performance