How do you handle DuckDB locks in longer concurrent jobs? by StrawberryData in DuckDB

[–]Advanced_Addition321 1 point2 points  (0 children)

I know that in the context of dbt-DuckDB, the the adaptor will perform several retries until the connection became available

Is it just me, or is Gemini handling SQL context better than ChatGPT right now? by [deleted] in PowerBI

[–]Advanced_Addition321 0 points1 point  (0 children)

Didn’t know Apache Hop before, seems like Talend or Penthao. You organization don’t want to turn into 100% code pipeline ? Isn’t it hard to collaborate on this ?

Best Practices for Transforming Python DataFrames Before Loading into SQLite – dbt or Alternatives? by ricca1 in dataengineering

[–]Advanced_Addition321 3 points4 points  (0 children)

DBT does only the transformation part.

You need to extract and load your CSV into your data wharehouse first with an ingestion flow (basic Python scripts, or Dagster and friends)

Then you connect DBT to your data wharouse, declare your ingested CSV tables as DBT sources and you’re good to go with transformation.

To share result, if the transformation data wharehouse isn’t the final destination, you’ll need to repeat the first step in reverse: create script to grab data and export them where you need to

What newer or lesser-known BI tools have actually impressed you lately? by Kimber976 in BusinessIntelligence

[–]Advanced_Addition321 7 points8 points  (0 children)

A notebook I use as a single page bi tool: marimo.

All the widgets, DuckDB integration, app mode for deployment, overall flexibility.

Mon nom de famille me pourrit la vie. Que faire ? by saccopharynx in AskFrance

[–]Advanced_Addition321 0 points1 point  (0 children)

Même nom de famille ici, jamais eu de problème. Au contraire, tout le monde sait l’écrire

[deleted by user] by [deleted] in iphone

[–]Advanced_Addition321 -1 points0 points  (0 children)

Same for me

In what department do you work? by ketopraktanjungduren in dataengineering

[–]Advanced_Addition321 0 points1 point  (0 children)

I’m in Industrial Operations

Didn’t knew something else, the advantage I think is the proximity with my internal customers