| title | description | hide | search | ||||
|---|---|---|---|---|---|---|---|
BigFunctions - Blog |
Blog Posts related to BigFunctions |
|
|
-
SQL is all you need{ target="_blank" }
Tired of complex data stacks?
Discover the SQL Data Stack: a new paradigm that uses SQL for data ingestion, transformation, and activation, empowering analysts and simplifying your data workflow
Read More :octicons-arrow-right-24:{ .md-button target="_blank" }
-
{ loading=lazy style=" display: block; margin-left: auto;" }
-
Bridge the gap between SQL and action{ target="_blank" }
Automate data workflows with BigFunctions, bridging the gap between SQL and action.
Trigger Slack notifications, enrich data, and integrate AI directly from BigQuery, all using SQL.
Read More :octicons-arrow-right-24:{ .md-button target="_blank" }
-
{ loading=lazy style=" display: block; margin-right: auto;" }
-
Unlock new use cases{ target="_blank" }
Run a simple SQL query to expose BigQuery data to a low latency API or to send BigQuery data to any destination.
Unlock:
- embedded analytics
- real-time feature store
- actions triggered by data
- ...sky is the limit
Read More :octicons-arrow-right-24:{ .md-button target="_blank" }
-
{ loading=lazy style="width: 100%; max-width: 400px; height: auto; display: block; margin-left: auto;" }
-
Open-Source Framework + Open-Source Functions{ target="_blank" }
This tutorial introduces BigFunctions.
Learn how to access and utilize these functions directly from BigQuery to enhance data analysis capabilities without additional setup.
Read More :octicons-arrow-right-24:{ .md-button target="_blank" }
-
{ loading=lazy style=" display: block; margin-right: auto;" }
-
Beyond SQL as a Pure Database Syntax{ target="_blank" }
BigFunctions extends SQL, enabling composable, reusable analytics patterns.
By embedding code into functions, it bridges SQL's limitations, reduces code footprint, and accelerates data insights.
Read More :octicons-arrow-right-24:{ .md-button target="_blank" }
-
{ loading=lazy style="width: 100%; max-width: 400px; height: auto; display: block; margin-left: auto;" }
-
Benefits of BigFunctions: A Data Engineering Perspective{ target="_blank" }
BigFunctions assists data engineers by providing them with 150+ open-source functions that are ready to go.
Functions allow them to extend BigQuery functionality, improve the reusability of BigQuery queries, and ensure consistent business logic across a company’s analytical operations.
Read More :octicons-arrow-right-24:{ .md-button target="_blank" }
-
{ loading=lazy style=" display: block; margin-right: auto;" }
-
BigFunctions is dataform's best friend{ target="_blank" }
With BigFunctions, any task can be run from SQL.
So any task can be orchestrated by SQL orchestrators such as dataform, dbt, sqlmesh or scheduled queries.
Read More :octicons-arrow-right-24:{ .md-button target="_blank" }
-
{ loading=lazy style="width: 100%; max-width: 400px; height: auto; display: block; margin-left: auto;" }
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_in-2025-analytics-engineers-will-build-data-apps-activity-7289945363237543936-GCiT?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>In 2025, Analytics Engineers will build Data-Apps</h3>
<p>Technologies make roles change.
Since the rise of cloud data-warehouses and the birth of dbt, data engineers don’t......
<p class="footer">2025-01-28 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigfunctions-activity-7288236835531591680-V3vC?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Have you met Timo?</h3>
<p>👉 To me, Timo Dechau creates some of the best content about Product Analytics.
I've been following him for two......
<p class="footer">2025-01-23 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2025-01-23_have_you_met_timo" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/timo-dechau_a-while-ago-i-wanted-a-daily-slack-update-activity-7288154281738661888-qSGG?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>A while ago, I wanted a daily Slack update on which kind of content was most viewed yesterday. It's nothing serious,...</h3>
<p>Luckily, I had just recorded a hands-on session with Paul Marcombes about BigFunctions. And we discussed exactly......</p>
<p class="footer">2025-01-23 • Timo Dechau</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_beyond-sql-as-a-pure-database-syntax-activity-7285925077592801280-eXXV?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>📢 I'm pleased to share the latest article by Benoit Pimpaud about BigFunctions!</h3>
<p>His article, "Beyond SQL as a Pure Database Syntax," really captures what we're trying to achieve.
I'm happy with......
<p class="footer">2025-01-17 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/pimpaudben_beyond-sql-as-a-pure-database-syntax-activity-7285716946547834880-TRtB?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>I recently explored SQL's limitations for analytics in a talk and in my writing, and I stand by these limits 🌶️</h3>
<p>But I recently realized that SQL's syntax isn't the real problem. The core issue lies in its underlying semantics –......</p>
<p class="footer">2025-01-16 • Benoit Pimpaud</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_whats-up-for-me-in-2025-more-open-source-activity-7285312281217753088-Eik8?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>What's up for me in 2025 👉 MORE Open-Source Data Products! 🤗</h3>
<p>🔹 2024
In 2024, I built 4 Open-Source Data Apps:
-
bigfunctions
-
airbyte-serverless
-
catalog-builder
-
......
<p class="footer">2025-01-15 • Paul Marcombes</p> </div> <div> <img src="http://github.com/assets/blog/2025-01-15_whats_up_for_me_in_2025__more_opensource_data_prod" loading=lazy> </div>
<div> <h3>Unifying Analytics Platform: what if you could have one tool to load, transform and activate data?</h3> <p>I had a great talk this morning with Burak, CEO of Bruin at DATANOSCO podcast from Stéphane.
Burak shared his......
<p class="footer">2025-01-14 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2025-01-14_unifying_analytics_platform_what_if_you_could_have" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/burakkarakan_all-in-one-data-platform-with-configuration-activity-7283080790899347456-gDLX?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>I am honored to get such high praise from the creator of BigFunctions!</h3>
<p>Thanks a lot for the kind words Paul, great to see our vision fits into what you would expect to see as well.
We......
<p class="footer">2025-01-09 • Burak Karakan</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_all-in-one-data-platform-with-configuration-activity-7282697551185645568-X-Io?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>All-in-one data-platform with configuration files. Why I love Bruin vision:</h3>
<p>1/ Modern-Data-Stack limitations
Modern-data-stack brought data tooling for any data service:
-
Fivetran for......
<p class="footer">2025-01-08 • Paul Marcombes</p> </div> <div> <img src="https://dummyimage.com/200x150/eee/eee" loading=lazy> </div>
<div> <h3>How to stay fast in a bigger company? Here's what I learnt during the last decade:</h3> <p>I started working 13 years ago in medical imaging.
We were 5 people in the company. We built ultrasound scanners......
<p class="footer">2025-01-07 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/sabrikaragonen_just-tried-something-really-amazing-with-ugcPost-7282078262535634945-yNHJ?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Just tried something really amazing with BigFunctions by Paul Marcombes.</h3>
<p>BigFunctions lets you use Python functions directly in BigQuery, and thanks to its prebuilt functions, you can even......</p>
<p class="footer">2025-01-06 • Sabri Karagönen</p>
</div>
<div>
<img src="http://github.com/assets/blog/2025-01-06_just_tried_something_really_amazing_with_bigfuncti" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/forward-data-conference_unlock-new-sql-capabilities-with-bigfunctions-activity-7280187059258986496-ImgG?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>🎯 Premier Replay de l'année : on démarre 2025 avec style !</h3>
<p>Les nouvelles capacités SQL avec BigFunctions !
• Découvrez comment simplifier vos requêtes complexes • Explorez......
<p class="footer">2025-01-01 • Forward Data Conference</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_static-bi-is-going-to-be-huge-heres-why-activity-7275408288698044416-vi6r?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Static BI is going to be huge! Here's why I am VERY excited 🤯:</h3>
<p>Static BI is about creating interactive dashboards on top of Parquet files.
It's trending since we can run duckdb......
<p class="footer">2024-12-19 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-12-19_static_bi_is_going_to_be_huge__heres_why_i_am_very" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_ga4-data-is-known-to-be-hard-to-explore-in-activity-7275053475732885504-juY1?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>GA4 data is known to be hard to explore in BigQuery. But this will change:</h3>
<p>Ali Izadi built dozens of handy SQL queries to cover areas like 𝗲𝘃𝗲𝗻𝘁, 𝘀𝗲𝘀𝘀𝗶𝗼𝗻, 𝗮𝗻𝗱 𝘂𝘀𝗲𝗿 𝘀𝗰𝗼𝗽𝗲 𝗮𝗻𝗮𝗹𝘆𝘀𝗶𝘀, 𝙚𝙘𝙤𝙢𝙢𝙚𝙧𝙘𝙚......</p>
<p class="footer">2024-12-18 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-12-18_ga4_data_is_known_to_be_hard_to_explore_in_bigquer" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_how-do-you-re-use-logic-in-bigquery-i-activity-7274361367212523520-DhQO?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>How do you re-use logic in BigQuery?</h3>
<p>I often need to get the Net Promoter Score from customer surveys.
The formula is "% promoters - %......
<p class="footer">2024-12-16 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-12-16_how_do_you_reuse_logic_in_bigquery" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_mkdocs-or-docusaurus-to-build-your-data-documentation-activity-7274143684432945152-ek0W?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Mkdocs or docusaurus to build your data documentation website?</h3>
<p>Both tools are used by millions of developers everyday to deploy their documentation website.
Which one to......
<p class="footer">2024-12-15 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_geocode-an-address-in-bigquery-using-datagouvfr-activity-7273316555021549569-O7Sh?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Geocode an address in bigquery using data.gouv.fr</h3>
<p>You want to get the latitude and longitude from an address for:
-
finding the nearest point of sale for a......
<p class="footer">2024-12-13 • Paul Marcombes</p> </div> <div> <img src="http://github.com/assets/blog/2024-12-13_geocode_an_address_in_bigquery_using_datagouvfr" loading=lazy> </div>
<div> <h3>Introducing the SQL Declarative-Data-Stack!</h3> <p>Modern Data Stack have tools to do everything with data.
Everything EXCEPT custom stuff.
➜ you end up with a ton......
<p class="footer">2024-12-12 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/sspaeti_declarativedatastack-ugcPost-7272906911648268288-u7sN?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>I aim to build and define the data stack with a "single function", including the entire data engineering lifecycle,...</h3>
<p>```
run_stack( serve( template='github://covid/covid_dashboard.md', data=transform( { 'groupb......
<p class="footer">2024-12-12 • Simon Späti</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-12-12_i_aim_to_build_and_define_the_data_stack_with_a_si" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_dbt-models-as-api-endpoints-activity-7270338616273391616-CbTS?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>How to expose dbt models as API endpoints:</h3>
<p>If your microservices could consume your dbt models with low latency, you'd unlock great use cases:
⇨ content......
<p class="footer">2024-12-05 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_expose-your-dbt-models-as-an-api-with-a-simple-activity-7270053513622110208-TaZT?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Expose your dbt models as an api with a simple dbt hook.</h3>
<p>This morning with Hachem LATRACH from Nickel we were at API Days Paris.
We explained several use cases where YOU......
<p class="footer">2024-12-04 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-12-04_expose_your_dbt_models_as_an_api_with_a_simple_dbt" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/balazsvajna_bigquery-googletrends-searchconsole-activity-7269979999682666496-f3v7?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>These days I write a lot about getting data from various different digital platforms into BigQuery*. The GA4 native...</h3>
<p>But there is even more. BigFunctions by Unytics offers even more extremely convenient ways to bring data into......</p>
<p class="footer">2024-12-04 • Balazs Vajna</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-12-04_these_days_i_write_a_lot_about_getting_data_from_v" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_speaking-with-data-people-is-always-full-activity-7269723948416696320-2DFX?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Speaking with data-people is always full of surprises.</h3>
<p>I like to chat with data-people from anywhere to get inspiration for my work or my side projects.
Today at......
<p class="footer">2024-12-03 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-12-03_speaking_with_datapeople_is_always_full_of_surpris" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_i-was-impressed-by-sherloq-this-week-sherloq-activity-7268176634438893568-j6Xt?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>I was impressed by Sherloq this week.</h3>
<p>Sherloq is a tool to organize and share your SQL queries.
What caught my eye is the UX:
It feels like an......
<p class="footer">2024-11-29 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-11-29_i_was_impressed_by_sherloq_this_week" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_self-served-data-analysts-are-much-more-impactful-activity-7267805672975564800-vlCQ?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Self-served data-analysts are much more impactful. Here’s why:</h3>
<p>We often talk about self-service analytics.
It’s a way to democratize data access in a company. It focuses on all......
<p class="footer">2024-11-28 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_text-to-sql-may-not-be-the-answer-for-self-activity-7267466431506571264-ZiVe?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Text to SQL may not be the answer for self service analytics.</h3>
<p>Text to SQL is great as a coding assistant for Data Analysts.
But it won’t help for business people to get trusted......
<p class="footer">2024-11-27 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigfunctions-is-a-framework-like-dbt-to-supercharge-activity-7266818186103214080-zFFk?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>BigFunctions is a framework like dbt to supercharge your data-warehouse:</h3>
<p>1/
- functions are deployed in yaml
- dbt models are declared in yaml/sql.
2/
-
functions are tested and deployed......
<p class="footer">2024-11-25 • Paul Marcombes</p> </div> <div> <img src="http://github.com/assets/blog/2024-11-25_bigfunctions_is_a_framework_like_dbt_to_supercharg" loading=lazy> </div>
<div> <h3>It’s been 2 years I publish on LinkedIn. But I never introduced myself. 5 things you don’t know about me:</h3> <p>1. I am father of 3 children of age 3, 8 and 10.
-
I started gymnastics 2 months ago. It feels like die and retry.......
<p class="footer">2024-11-24 • Paul Marcombes</p> </div> <div> <img src="https://dummyimage.com/200x150/eee/eee" loading=lazy> </div>
<div> <h3>Well, I’m nowhere near Kestra and their 10000+ stars,</h3> <p>But it makes me something to have reached 600 ⭐️ with bigfunctions today 🥹
Slowly but surely.
Huge Thanks to the......
<p class="footer">2024-11-12 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-11-12_well_im_nowhere_near_kestra_and_their_10000_stars" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_unify-batch-real-time-in-data-at-nickel-activity-7260557938962894848-PBK9?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Unify batch / real time in data 🤝</h3>
<p>At Nickel, we've built a configurable data engine:
✅ that allows data analysts to deploy algorithms ✅ in batch or......
<p class="footer">2024-11-08 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_sqlmesh-vs-dbt-i-bet-for-sqlmesh-simply-activity-7260195572647624706-Iwj3?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>sqlmesh vs dbt?</h3>
<p>I bet for sqlmesh.
Simply because sqlmesh paid product does not compete with their open-source product. It’s......
<p class="footer">2024-11-07 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-11-07_sqlmesh_vs_dbt" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_la-data-en-temps-r%C3%A9el-chez-nickel-activity-7259852897339719680-dJdG?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Unifions le batch / temps réel dans la data 🤝</h3>
<p>Chez Nickel on a construit un moteur de calculs data configurable:
✅ qui permet aux data-analystes de déployer des......
<p class="footer">2024-11-06 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/iziday_nickel-les-avantages-dune-plateforme-de-activity-7259841611243646979-9713?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>🎧 NOUVEAU PODCAST DISPONIBLE !</h3>
<p>Dans cet épisode, nous avons le plaisir de recevoir Paul Marcombes, Head of Data chez Nickel, afin d'échanger sur la......</p>
<p class="footer">2024-11-06 • iziday</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/forward-data-conference_speaker-announcement-were-thrilled-to-activity-7256571649079095296-i8RR?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>[SPEAKER ANNOUNCEMENT] We're thrilled to announce that Paul Marcombes from Nickel will be speaking at the Forward...</h3>
<p>Paul is Head of Data at Nickel, and will how to unlock new SQL capabilities with BigFunctions, a framework for......</p>
<p class="footer">2024-10-28 • Forward Data Conference</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-10-28_speaker_announcement_were_thrilled_to_announce_tha" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/hymaia_comment-nickel-transforme-son-entreprise-activity-7255587097636474881-cjXW?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>[Replay du vendredi] Comment Nickel transforme son entreprise grâce à l'IA</h3>
<p>🚀 Paul Marcombes, Head of Data de Nickel, présente comment l'entreprise utilise l'IA pour améliorer l’expérience......</p>
<p class="footer">2024-10-25 • Hymaïa</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/antgiraud_bigfunctions-activity-7251856908347699202-2UBB?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>👨🔧 New BigFunctions : load_file(url, file_type, destination_table, options)</h3>
<p>> Download web file into destination_table in BigQuery with SQL
Under the BigFunctions hood : DuckDB & Ibis......
<p class="footer">2024-10-15 • Antoine Giraud</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-10-15__new_bigfunctions__loadfileurl_filetype_destinatio" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_do-you-have-a-lot-of-text-data-categorize-activity-7247911268727029760-4kiA?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Do you have a lot of text data? ➜ Categorize it! ✨</h3>
<p>The easiest way to get a holistic view of your text data is to categorize it.
You'll instantly get:
➜ the main......
<p class="footer">2024-10-04 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-10-04_do_you_have_a_lot_of_text_data__categorize_it_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_easiest-way-to-get-a-public-csv-file-into-activity-7245098813319712768-sJL3?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Easiest way to Get a Public CSV file into BigQuery 📝</h3>
<p>I had great fun to do live coding with Javier de la Torre from CARTO.
Within 20 minutes we could deploy this......
<p class="footer">2024-09-26 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-09-26_easiest_way_to_get_a_public_csv_file_into_bigquery" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-googlecloud-activity-7244970986381479937-CASX?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Extract Webpage Data with SQL 🌐!</h3>
<p>Get structured data.
Directly from webpages.
Into your data-warehouse.
Using a prompt embedded in a SQL......
<p class="footer">2024-09-26 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-09-26_extract_webpage_data_with_sql_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/antgiraud_bigfunctions-powerbi-bigquery-activity-7244239220641251330-RBda?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>👨🔧 New contribution to BigFunctions : `refresh_powerbi`</h3>
<p>This function let you launch a PowerBI semantic model (dataset) refresh 📊
from BigQuery in SQL
Documentation here 👉......
<p class="footer">2024-09-24 • Antoine Giraud</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-09-24__new_contribution_to_bigfunctions__refreshpowerbi" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_noabrinstallabrneeded-bigfunctions-bigquery-activity-7242862602559655937-CSQU?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Converse with your User Feedbacks inside BigQuery ✨💬</h3>
<p>Gen AI features provides new dimensions for data-analysis.
You can:
-
Transform any text such as user feedbacks......
<p class="footer">2024-09-20 • Paul Marcombes</p> </div> <div> <img src="http://github.com/assets/blog/2024-09-20_converse_with_your_user_feedbacks_inside_bigquery_" loading=lazy> </div>
<div> <h3>I just tried the brand new Conversational Analytics from Looker Studio. Here's 👇 what I learnt</h3> <p>All BI teams are working hard to enable users to get insights from natural language questions.
Looker Studio is no......
<p class="footer">2024-09-18 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-09-18_i_just_tried_the_brand_new_conversational_analytic" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_i-am-stunned-by-the-quality-of-this-genai-activity-7240717718746730497-mUi9?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>I am stunned by the quality of this genAI created podcast 😲</h3>
<p>I just gave NotebookLM (a new tool made available by google) two urls from BigFunctions website.
And here is the......
<p class="footer">2024-09-14 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_data-analysis-is-structured-data-enough-activity-7240278912491028480-8U4A?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Data Analysis: Is Structured Data Enough?</h3>
<p>You can be the greatest data-analyst, you will never be able to uncover an insight for which you don't have the......</p>
<p class="footer">2024-09-13 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-09-13_data_analysis_is_structured_data_enough" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_surface-the-search-behind-the-rag-retrieval-activity-7239892809229504513-MxIu?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Surface the search behind the RAG 🔎 !</h3>
<p>Retrieval Augmented Generation is one of the best way to get started with GenAI in a company.
Mathilde Gorieu made......
<p class="footer">2024-09-12 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-09-12_surface_the_search_behind_the_rag__" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_lets-talk-about-nickel-genai-use-cases-at-activity-7239181414254931968-aFPz?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Let's talk about Nickel GenAI use cases at Google Paris Office!</h3>
<p>With Mathilde Gorieu we're going to share today what we've learned at Nickel while implementing several RAG use......</p>
<p class="footer">2024-09-10 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-09-10_lets_talk_about_nickel_genai_use_cases_at_google_p" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/masthead-data_bigquery-champions-level-up-your-data-activity-7232297664124514305-q54g?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>🦸 BigQuery Champions, Level Up Your Data Work with BigFunctions!</h3>
<p>Data engineers, are you tired of manually building and managing BigQuery functions?
BigFunctions is revolutionizing......
<p class="footer">2024-08-22 • Masthead Data</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-activity-7224670243372109825-hlMZ?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Refresh a Tableau Workbook with a SQL command</h3>
<p>dbt provides post-hooks.
Post-hooks are SQL queries that run after model creation.
Refresh_tableau is a function......
<p class="footer">2024-08-01 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-08-01_refresh_a_tableau_workbook_with_a_sql_command" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/ethanaaron_the-stuff-no-one-will-tell-you-about-running-activity-7224048593538560002-dICF?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>The stuff no one will tell you about running a data team:</h3>
<p>1. You'll might need to say NO to more stuff
-
You can say NO to more stuff
-
You should say NO to more stuff 4.......
<p class="footer">2024-07-30 • Ethan Aaron</p> </div> <div> <img src="https://dummyimage.com/200x150/eee/eee" loading=lazy> </div>
<div> <h3>Put the right label to a value</h3> <p>Available to anyone in BigQuery
Thanks Bartosz Figas for this great contribution to BigFunctions.
Function doc:......
<p class="footer">2024-07-29 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-07-29_put_the_right_label_to_a_value" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigfunctions-airbyte-bigquery-activity-7222133476475498496-W_BK?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Load data from 250+ Sources with a single SQL query!</h3>
<p>`get_data` bigfunction is available in BigQuery.
It loads data from your favorite SAAS.
No install is needed.
It......
<p class="footer">2024-07-25 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-07-25_load_data_from_250_sources_with_a_single_sql_query" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_banktech-day-organis%C3%A9-par-finance-innovation-activity-7203679225927647232-xdKo?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>BankTech Day organisé par Finance Innovation se déroulera le 13 juin 2024 au Cloud Business Center !</h3>
<p>Je participerai à l'atelier : L'Expérience client à l’ère de la data : banques & fintechs en quête......</p>
<p class="footer">2024-06-04 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-06-04_banktech_day_organis_par_finance_innovation_se_dro" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-googlecloud-activity-7201971338377351168-DqGn?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Stop struggling with nested JSON in BigQuery! 🤼♂️ Flatten your data 🚀</h3>
<p>Tired of endlessly navigating nested fields in your JSON data? 😩
You're not alone. It's like searching for a needle......
<p class="footer">2024-05-30 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-05-30_stop_struggling_with_nested_json_in_bigquery__flat" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-airbyte-bigfunctions-activity-7201509980221358080-zBHb?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Loading data into BigQuery should be as simple as a SQL query 👅 !</h3>
<p>Airbyte built awesome open-source connectors to move data into your warehouse.
What if we could run them via a......
<p class="footer">2024-05-29 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-05-29_loading_data_into_bigquery_should_be_as_simple_as_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_supercharge-bigquery-with-bigfunctions-activity-7199683895712202753-lP_-?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Build your own catalog of BigQuery functions 🌌</h3>
<p>I like this article from Jake Holmquist ☁️ as it describes the two sides of bigfunctions:
➡️ Effortless access to......
<p class="footer">2024-05-24 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-dataengineering-activity-7197166459716804608-DvLS?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Getting public data into BigQuery has never been easier ☀️</h3>
<p>Thanks to remote functions, you can get data from any website into BigQuery with a simple SQL query 🤗
Here is an......
<p class="footer">2024-05-17 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-05-17_getting_public_data_into_bigquery_has_never_been_e" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-dataanalysis-activity-7196774410429579264-M-xW?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>It's been a while since I've been this excited about a BigQuery function! 🎢</h3>
<p>You can ask any question to the user reviews of an app (from the app store). 😮
1️⃣ The last 500 reviews are......
<p class="footer">2024-05-16 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-05-16_its_been_a_while_since_ive_been_this_excited_about" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigfunctions-now-supports-udaf-user-defined-activity-7195744263567990785-35Kt?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Great contribution to BigFunctions 👏 Axel Thevenot.</h3>
<p>You made my day by adding support to UDAF + adding this great function.
🙌 ...
<p class="footer">2024-05-13 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_dataengineering-airbyte-activity-7169280585352335360-LVkv?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>I am quite excited with PyAirbyte 😲 (Airbyte connectors available from python)</h3>
<p>Airbyte (the leading open-source solution to move your data to your data-warehouse) finally released their......</p>
<p class="footer">2024-03-01 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-03-01_i_am_quite_excited_with_pyairbyte___airbyte_connec" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_datanalytics-analyticsengineering-dataengineering-activity-7160542653451816961-8PmJ?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>What is a Staff Analytics-Engineer and why we need them?</h3>
<p>Embed data-people in teams to scale
One way to scale data analysis is to embed data people in teams, tribes,......
<p class="footer">2024-02-06 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-02-06_what_is_a_staff_analyticsengineer_and_why_we_need_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-dataanalysis-activity-7155903739478904832-9W9m?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>What if data-analysts could take actions themselves 🏀?</h3>
<p>We had a great presentation from Tangi Gouez and Manuel Cellier from Dashlane last week at Nickel. They told us......</p>
<p class="footer">2024-01-24 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-01-24_what_if_dataanalysts_could_take_actions_themselves" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-bigframes-activity-7155499433772666881-kkur?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>When to use BigQuery Dataframes over SQL ?</h3>
<p>Querying your BigQuery data in SQL is very natural and efficient but you want to use BigQuery Dataframes (aka......</p>
<p class="footer">2024-01-23 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2024-01-23_when_to_use_bigquery_dataframes_over_sql_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-gcp-activity-7143510443934826497-O2bg?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Get the Country of an IP address in BigQuery 🌐👀</h3>
<p>Execute this query in your BigQuery :
select bigfunctions.eu.ip2country('152.216.7.110')
It will tell you the IP......
<p class="footer">2023-12-21 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-12-21_get_the_country_of_an_ip_address_in_bigquery_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_airbyte-serverless-dataengineering-activity-7141404312785604608-a-lI?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Moving data to your Data-Warehouse has never been easier 🏌♂️ !</h3>
<p>Every data project starts with moving data from different sources to your data-warehouse for analysis. To this end,......</p>
<p class="footer">2023-12-15 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-12-15_moving_data_to_your_datawarehouse_has_never_been_e" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/aleksandr-ignatenko_bigquery-sql-bigfunctions-activity-7141037483680591875-5PST?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>BigFunctions - steroids for BigQuery</h3>
<p>If you're not familiar with or not using BigFunctions, be sure to check out the documentation – it's worth it.......</p>
<p class="footer">2023-12-14 • Alex Ignatenko</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-12-14_bigfunctions__steroids_for_bigquery" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-dataengineering-activity-7141003906012082176-rCxd?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Testing Gemini, Google's latest AI model, from BigQuery</h3>
<p>Excited to explore Google's latest AI model, I compared Gemini with other Google AI models using the 'ask_ai'......</p>
<p class="footer">2023-12-14 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-12-14_testing_gemini_googles_latest_ai_model_from_bigque" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/axel-thevenot_bigquery-dataengineering-analytics-activity-7139876215447785472-tld3?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>BigQuery: Array Union & Array Intersect now at your fingertips! 🐣</h3>
<p>BigFunctions has just release two easy but useful functions to obtain the union and/or intersection of two......</p>
<p class="footer">2023-12-11 • Axel Thevenot</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-12-11_bigquery_array_union__array_intersect_now_at_your_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_%F0%9D%97%A6%F0%9D%97%94%F0%9D%97%A9%F0%9D%97%98-%F0%9D%97%A7%F0%9D%97%9B%F0%9D%97%98-%F0%9D%97%97%F0%9D%97%94%F0%9D%97%A7%F0%9D%97%98-rejoignez-nous-activity-7138204518353203202-Pwuk?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Want a demo of Serverless Data Pipelines?</h3>
<p>✅ Move data with Airbyte Serverless
✅ Transform it with dbt ✅ Orchestrate with Google Workflows
Airbyte is......
<p class="footer">2023-12-06 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-gcp-activity-7133848847801290753--ebl?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Extract info from a phone number in BigQuery 📱👀</h3>
<p>Execute this query in your BigQuery :
select bigfunctions.eu.phone_number_info('+33123456789', null)
and you'll......
<p class="footer">2023-11-24 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-11-24_extract_info_from_a_phone_number_in_bigquery_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_data-catalog-is-key-for-your-data-mesh-strategy-activity-7133393773518053376-weGa?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Data catalog is key for your data-mesh strategy. Why building vs buying?</h3>
<p>I was at a (great) c2c event last night and I realized two things:
1️⃣ Without a good catalog, your data-mesh......
<p class="footer">2023-11-23 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-11-23_data_catalog_is_key_for_your_datamesh_strategy_why" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/google-cloud_famous-assists-lionel-messi-with-argentina-ugcPost-7128849050732244993-J8TK?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Famous assists:</h3>
<p>⚽ Lionel Messi with Argentina
👠 Andy Sachs with Miranda Priestly 🇺🇸 Gary Walsh with Selina Meyer ☁️ Duet AI with......
<p class="footer">2023-11-10 • Google Cloud</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-dataengineering-activity-7122832228438478848-POer?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Here’s what I do when I can’t find a BigQuery function to solve a problem 👇</h3>
<p>Yesterday, again, I needed to do a transform for which 𝗜 𝗰𝗼𝘂𝗹𝗱 𝗻𝗼𝘁 𝗳𝗶𝗻𝗱 𝗮𝗻𝘆 𝗻𝗮𝘁𝗶𝘃𝗲 𝗕𝗶𝗴𝗤𝘂𝗲𝗿𝘆 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻. 🧐 (decode......</p>
<p class="footer">2023-10-25 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-10-25_heres_what_i_do_when_i_cant_find_a_bigquery_functi" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/khuyen-tran-1401_if-you-want-to-build-a-web-app-seamlessly-ugcPost-7119688114297597952-CP2u?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>If you want to build a web app seamlessly within your Jupyter Notebook, use Mercury.</h3>
<p>Link to Mercury: https://lnkd.in/gpV3Sqk3
...
<p class="footer">2023-10-16 • Khuyen Tran</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_github-unyticsairbyteserverless-airbyte-activity-7118520351256391680-mRFa?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Introducing Airbyte-Serverless for Airbyte & Serverless lovers ❤️</h3>
<p>Airbyte is a must-have in your data-stack with its 𝗰𝗮𝘁𝗮𝗹𝗼𝗴 𝗼𝗳 𝗼𝗽𝗲𝗻-𝘀𝗼𝘂𝗿𝗰𝗲 𝗰𝗼𝗻𝗻𝗲𝗰𝘁𝗼𝗿𝘀 𝘁𝗼 𝗺𝗼𝘃𝗲 𝘆𝗼𝘂𝗿 𝗱𝗮𝘁𝗮 𝗳𝗿𝗼𝗺 𝗮𝗻𝘆......</p>
<p class="footer">2023-10-13 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_github-unyticsairbyteserverless-airbyte-activity-7117595324566626305-XLjT?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Introducing Airbyte-Serverless for Airbyte & Serverless lovers ❤️</h3>
<p>Airbyte is a must-have in your data-stack with its 𝗰𝗮𝘁𝗮𝗹𝗼𝗴 𝗼𝗳 𝗼𝗽𝗲𝗻-𝘀𝗼𝘂𝗿𝗰𝗲 𝗰𝗼𝗻𝗻𝗲𝗰𝘁𝗼𝗿𝘀 𝘁𝗼 𝗺𝗼𝘃𝗲 𝘆𝗼𝘂𝗿 𝗱𝗮𝘁𝗮 𝗳𝗿𝗼𝗺 𝗮𝗻𝘆......</p>
<p class="footer">2023-10-10 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_lessismore-data-activity-7117433624060116992-cqi9?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>You probably have too many dashboards…</h3>
<p>… how do you want people to find the information they need from this overcrowded space 🧐?
At Nickel, since we had......
<p class="footer">2023-10-10 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-10-10_you_probably_have_too_many_dashboards" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-finops-gcp-activity-7115977007707893761-B_SO?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Rule № 1️⃣ for reducing BigQuery costs:</h3>
<p>The best data is the data you don’t store!
-
I just deleted 3433 tables.
-
And I instantly felt way better. 🤗 -......
<p class="footer">2023-10-06 • Paul Marcombes</p> </div> <div> <img src="http://github.com/assets/blog/2023-10-06_rule__1_for_reducing_bigquery_costs" loading=lazy> </div>
<div> <h3>Beware of dbt tests…. your money may disappear 💸</h3> <p>At Nickel, as dbt jobs costs kept rising we decided to take action. ☝️
This is when the great Rémi BENOIST decided......
<p class="footer">2023-10-05 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-10-05_beware_of_dbt_tests_your_money_may_disappear_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-gcp-googlecloud-activity-7115268234395676672-GCtj?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>From 1400 $ to 1 $ a month 👉 my best BigQuery optimization 🤑</h3>
<p>If you are into reducing BigQuery costs you may have already explored:
1️⃣ partitioning your tables 2️⃣ requiring a......
<p class="footer">2023-10-04 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-10-04_from_1400__to_1__a_month__my_best_bigquery_optimiz" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_composable-cdp-are-dead-long-live-data-warehouse-activity-7108467280665042945-oQUj?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Composable CDP are dead, long live Data-Warehouse Connected Products 🔌?</h3>
<p>It makes no sense to waste effort building a 360° Customer View several times over with several tools. 🧐
That's how......
<p class="footer">2023-09-15 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-09-15_composable_cdp_are_dead_long_live_datawarehouse_co" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_self-service-r%C3%AAve-ou-r%C3%A9alit%C3%A9-cest-activity-7094969227513626624-yTga?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Tout sur le self-service analytics ou l’autonomie dans l’analyse de données.</h3>
<p>A écouter sur la plage ou au bord de la piscine sans modération.
Je retiens de cette discussion avec Christophe......
<p class="footer">2023-08-09 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-to-datastore-via-remote-functions-activity-7086646820033945600-Kqtg?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Data-Engineering practices are changing!</h3>
<p>I love this very educational video from Richard Shenghua (升华) He which explains how a SQL query can export BigQuery......</p>
<p class="footer">2023-07-17 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-dataengineering-activity-7076847468805550080-sENE?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Expose your BigQuery data in a real-time database from `dbt` 💎</h3>
<p>BigQuery is perfect for massive calculations, but is not designed to obtain key-value data very quickly.
And in the......
<p class="footer">2023-06-20 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-06-20_expose_your_bigquery_data_in_a_realtime_database_f" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-dataengineering-activity-7075409796245381120-PIaU?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Run any python code in BigQuery 🐍</h3>
<p>When Axel Thevenot from Devoteam came to me and told me:
👉 ❝ What if we had a function capable of executing any......
<p class="footer">2023-06-16 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-06-16_run_any_python_code_in_bigquery__" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-dataengineering-activity-7072497509008334848-TNy6?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Sync any dbt model into Google Sheet at `dbt run` 👌</h3>
<p>Keep your finance team updated ✅ (or any other spreadsheet-lover ❤️) !
Thanks to dbt post-hooks and the brand-new......
<p class="footer">2023-06-08 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-06-08_sync_any_dbt_model_into_google_sheet_at_dbt_run__" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-gcp-activity-7067172657221263360-cJaZ?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>😲 Ask Questions to BigQuery in English !</h3>
<p>Every BigQuery user can NOW ask questions over their data in English.
The BigQuery function 'ask_my_data' converts......
<p class="footer">2023-05-24 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-05-24__ask_questions_to_bigquery_in_english__" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-dataengineering-activity-7064560205765693440-aIbv?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Generating PDF invoices from BigQuery 📄</h3>
<p>You want to generate PDF files from BigQuery to:
1️⃣ Generate custom PDF reports with data 2️⃣ Generate customized......
<p class="footer">2023-05-17 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-05-17_generating_pdf_invoices_from_bigquery__" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_palm2-bigquery-bigfunctions-activity-7062713193789300736-YU2h?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Generative AI is available in BigQuery and I just learned two things 🧠</h3>
<p>Google released new language models paLM2 this wednesday and I could not wait to add a bigquery integration. 😊
👉......
<p class="footer">2023-05-12 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-05-12_generative_ai_is_available_in_bigquery_and_i_just_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-excel-report-the-easy-way-activity-7061995791602606080-hp60?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>BigQuery Excel Report in your inbox ➜ the easy way!</h3>
<p>Sending a BigQuery table as an Excel file to your team simply requires the execution of a SQL query 👀.
(Thanks to......
<p class="footer">2023-05-10 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-activity-7059821460420235264-jpDf?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Zero-ETL in BigQuery: there is More ➕</h3>
<p>Did you know you can query any API from BigQuery 👀?
By enabling data-practitioners to query data-sources without......
<p class="footer">2023-05-04 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-05-04_zeroetl_in_bigquery_there_is_more_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-activity-7059096700816089091-8N06?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Sending Slack notifications from BigQuery 💬</h3>
<p>👀 Guillaume Pivette from Neoxia just created a new function to send Slack messages with a simple BigQuery SQL query......</p>
<p class="footer">2023-05-02 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-05-02_sending_slack_notifications_from_bigquery_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-activity-7057647104319442944-qEzb?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Sending notifications from BigQuery 💌</h3>
<p>Sending Google Chat notifications from BigQuery has never been easier.
👉 Shivam Singh created a simple BigQuery......
<p class="footer">2023-04-28 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-04-28_sending_notifications_from_bigquery_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-activity-7056559998029418496-sTRi?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Generate fake data in BigQuery</h3>
<p>While working in a non-production environment you may want to generate fake data for testing purposes.
Shivam Singh......
<p class="footer">2023-04-25 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-04-25_generate_fake_data_in_bigquery" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-activity-7054363025339736064-zRQf?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>De-identifying text in BigQuery</h3>
<p>ELT has a drawback over ETL.
As you get data without transform from your sources into you warehouse, (using......
<p class="footer">2023-04-19 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-04-19_deidentifying_text_in_bigquery" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigfunctions-data-activity-7052963262488797184-BO1B?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Celebrating 🥳 10 contributors to help data practicioners</h3>
<p>When I launched bigfunctions, an open-source product to help data analysts not reinvent the wheel, I wasn't even......</p>
<p class="footer">2023-04-15 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-04-15_celebrating__10_contributors_to_help_data_practici" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_snowflake-bigfunctions-bigquery-activity-7052364212555173889-y7aH?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Tonight I met Felipe Hoffa from snowflake</h3>
<p>Felipe Hoffa inspired me for a long time by writing content about data-warehousing and in particular:
👉 how to......
<p class="footer">2023-04-13 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-04-13_tonight_i_met_felipe_hoffa_from_snowflake" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunction-activity-7051947091337596928-FTwe?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>5 reasons why you want to use this bigquery function</h3>
<p>1️⃣ Check that addresses exist
2️⃣ Clean up typos in addresses 3️⃣ Get address hierarchy with address components 4️⃣......
<p class="footer">2023-04-12 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-04-12_5_reasons_why_you_want_to_use_this_bigquery_functi" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-activity-7051519957183913984-yr4J?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>ELT replaced ETL</h3>
<p>Most transformations are now performed in SQL in the data warehouse. For specific needs such as parsing xml data,......</p>
<p class="footer">2023-04-11 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-04-11_elt_replaced_etl" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_data-realtime-dataanalysts-activity-7041808042627092480-pXPO?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Les data-analysts ne devraient pas se contenter de faire des analyses de données pour obtenir des insights.</h3>
<p>@Data-Analysts,
🚀 Impactez directement l'experience utilisateur avec des algos data. 🚀
Je ne suis pas peu fier......
<p class="footer">2023-03-15 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2023-03-15_les_dataanalysts_ne_devraient_pas_se_contenter_de_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigfunctions-bigquery-activity-7011289613080100865-Czif?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>The modern data stack was founded to give full autonomy to data-analysts BUT we miss essential features...</h3>
<p>What if a data-analyst needs to compute the sentiment score of a customer survey comment. He would ask a......</p>
<p class="footer">2022-12-21 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2022-12-21_the_modern_data_stack_was_founded_to_give_full_aut" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigfunctions-bigquery-bigfunctions-activity-7010568101637332993-cnGD?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>How I created an open-source repository after meeting a Himalayan climber.</h3>
<p>Like some of us, I have dreamed of creating a product for a long time. But every time I wanted to get started, I......</p>
<p class="footer">2022-12-19 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2022-12-19_how_i_created_an_opensource_repository_after_meeti" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigquery-bigfunctions-activity-7009072015533854720-55Ib?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Discretize continuous value to faster Data-Analysis in bigquery</h3>
<p>To help your data-analysis you may want to discretize continuous values into bins of equal width.
1️⃣ You can then......
<p class="footer">2022-12-15 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2022-12-15_discretize_continuous_value_to_faster_dataanalysis" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-advanced-json-queries-activity-7008339733281918977-eblE?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>🔵 Advanced Json Query in BigQuery 👇</h3>
<p>BigQuery native json support is nice but limited. We need more! 🚧
💥 sid ali sadi from Esmoz is bringing advanced......
<p class="footer">2022-12-13 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-activity-7006941275996225536-ErDP?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>🔵 BigQuery json made easy!</h3>
<p>Oups he did it again!
sid ali sadi from Esmoz created some very nice bigquery functions callable by anyone from......
<p class="footer">2022-12-09 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2022-12-09__bigquery_json_made_easy" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigquery-bigfunctions-activity-7006666393081323520-M41Y?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>🔵 Where will this end? Yesterday, a new contributor deployed open BigQuery functions to clean up text. And...</h3>
<p>Today, another contributor deployed some more!
A big Thanks 🙏 Benjamin Tabet for this contribution that will......
<p class="footer">2022-12-08 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2022-12-08__where_will_this_end_yesterday_a_new_contributor_d" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_4-bonnes-raisons-de-larguer-sa-stack-data-activity-7006549739550703617-jUbE?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>👉 Donnons le pouvoir aux data-analysts!</h3>
<p>Complètement d'accord Robin Conquet.
Rendons les data-analysts autonomes sur toute la chaîne (de la collecte, aux......
<p class="footer">2022-12-08 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-activity-7006173879899414528-l-YR?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>🔵 BigQuery Text Cleaning and Text Comparison</h3>
<p>👀 sid ali sadi from Esmoz did a great job by adding the new `remove_accents` bigquery function callable by anyone......</p>
<p class="footer">2022-12-07 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2022-12-07__bigquery_text_cleaning_and_text_comparison" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_why-dbts-semantic-layer-sucks-activity-7001074129462255616-9SHt?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Great article Robert Yi to get a view of semantic layer strategic choices.</h3>
<p>...</p>
<p class="footer">2022-11-23 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-activity-6999355772329467904-ift0?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>🔵 BigQuery Auto Date Cleaning!</h3>
<p>Sebabrata Banerjee (Sebo) did a great video tutorial to use regex for date cleaning 👨💻.
What if you don't know......
<p class="footer">2022-11-18 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2022-11-18__bigquery_auto_date_cleaning" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-bigfunctions-activity-6991791325377404928-X4_C?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>🔵 BigQuery arrays made easy!</h3>
<p>I recently discovered the great 'sql-snippets' open-source repository from Taylor Brownlow from Count.
I ❤️ the......
<p class="footer">2022-10-28 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2022-10-28__bigquery_arrays_made_easy" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_datacleaning-sql-dbt-activity-6990801218084253696-m1RJ?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Totally agree with you @Madison Schott! ➜ opensource for data is great to avoid reinventing the wheel and to share...</h3>
<p>Mateusz Klimek: I took the liberty of re-developing your `clean_additional_whitespaces` dbt macro as a public......</p>
<p class="footer">2022-10-25 • Paul Marcombes</p>
</div>
<div>
<img src="https://dummyimage.com/200x150/eee/eee" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_%F0%9D%90%91%F0%9D%90%9E%F0%9D%90%A3%F0%9D%90%A8%F0%9D%90%A2%F0%9D%90%A0%F0%9D%90%A7%F0%9D%90%9E%F0%9D%90%B3-%F0%9D%90%A6%F0%9D%90%A8%F0%9D%90%A2-%F0%9D%90%A5%F0%9D%90%AE%F0%9D%90%A7%F0%9D%90%9D%F0%9D%90%A2-%C3%A0-%F0%9D%90%86-activity-6986619669633716224-WNUJ?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Rejoignez-moi lundi à Google Next Recap France:</h3>
<p>- si vous voulez tout savoir sur le scaling des usages data chez Nickel grâce à GCP.
-
si vous êtes intrigués par......
<p class="footer">2022-10-14 • Paul Marcombes</p> </div> <div> <img src="http://github.com/assets/blog/2022-10-14_rejoignezmoi_lundi__google_next_recap_france" loading=lazy> </div>
<div> <h3>🌐 Furcy Pin brings Graph Algorithms to BigQuery!</h3> <p>What a pleasure to see Furcy brings the first Graph Algorithm to BigQuery as an open function callable by anyone......</p> <p class="footer">2022-10-10 • Paul Marcombes</p> </div> <div> <img src="http://github.com/assets/blog/2022-10-10__furcy_pin_brings_graph_algorithms_to_bigquery" loading=lazy> </div>
<div> <h3>👀 What if common BigQuery functions were available from a unique place?</h3> <p>Last week, a question was asked in our modern-data-stack slack-community:
"how do you get if a date is a......
<p class="footer">2022-10-03 • Paul Marcombes</p>
</div>
<div>
<img src="http://github.com/assets/blog/2022-10-03__what_if_common_bigquery_functions_were_available_" loading=lazy>
</div>
</a>
<hr>
<a class="blog-post-abstract" href="https://www.linkedin.com/posts/paul-marcombes_bigquery-data-dataanalytics-activity-6980085040453980161-QRwu?utm_source=combined_share_message&utm_medium=member_desktop" target="_blank">
<div>
<h3>Et si on pouvait voir le profiling des données dans BigQuery ?</h3>
<p>C'est important quand on commence un projet data de:
-
👃 sentir les données,
-
👀 savoir s'il y a des outliers,
-
🌊......
<p class="footer">2022-09-26 • Paul Marcombes</p> </div> <div> <img src="http://github.com/assets/blog/2022-09-26_et_si_on_pouvait_voir_le_profiling_des_donnes_dans" loading=lazy> </div>
<div> <h3>Ravi de pouvoir exposer comment dbt permet de mettre le data-warehouse cloud tel que BigQuery ou Snowflake au centre...</h3> <p>- en rendant possible l’autonomie des data-analysts sur toute la chaîne: de l’ingestion des données à l’activation......</p> <p class="footer">2022-09-07 • Paul Marcombes</p> </div> <div> <img src="https://dummyimage.com/200x150/eee/eee" loading=lazy> </div>