42 questions
Best practices
0
votes
2
replies
134
views
How to incrementally merge daily CSV delta updates into a master file without losing expired records?
I am building a data pipeline to create a cumulative master dataset from daily CSV exports generated by a booking system.
Context & Data Structure
Source: A daily CSV file containing status ...
Score of 1
1 answer
89 views
copy incremetal data from shopify using copy activity in azure synapse using version 2.0 linked service
currently we are fetching data from shopify using copy activity with version 1.0 shopify linked service. version 1.0 is going to get deprecated by the 3rd week of Oct 2025. version 1.0 supports query ...
Score of 0
1 answer
111 views
Difference between checkpoints and change streams
I am trying to understand the difference between the two most common strategies of incremental data load.
What is the difference between a streaming checkpoint vs a change stream in Databricks Delta ...
Score of 2
1 answer
370 views
How to do incremental refresh in power bi without duplication
I have a table like following in my SQL Database and is loaded into Power BI where the Last Update Date have been setup for Incremental Refresh with 2 days windows.
Primary Key
Col B
Last Update Date
...
Score of 0
1 answer
105 views
Will BigQuery Incremental Transfer reload files when GCS lifecycle archives them?
I’m evaluating BigQuery Data Transfer Service to ingest daily files that land in a GCS bucket.
My goal:
Load each new daily file once into BigQuery.
After 30 days, archive files using a GCS ...
Score of 0
1 answer
170 views
Business Central API to Azure SQL Database - ADF will not interact with or filter incoming API data
We are trying to incrementally load Business Central API data to an Azure SQL database in ADF. ADF only seems to allow you to copy the API data to the target source, however nothing happens when you ...
Score of 0
1 answer
138 views
How to implement incremental load on ADF
We have 2 folders in adls source and destination. source folder has 4 file and destination has 3. How can we implement the Increment load in ADF. What all activities we have to perform to achieve ...
Score of 0
1 answer
901 views
Is it a good practice to use update_timestamp for incremental loading in DBT with insert_overwrite strategy?
Suppose I have a dbt/bigquery model reading from a simple upstream model partitionned by day using "partition_date" and clustered by "update_timestamp" and that would look like
the ...
Score of 0
0 answers
281 views
How to Use BigQuery Views for Incremental Data Loading in BI Tools When They Can’t Utilize _TABLE_SUFFIX?
I’m currently working with Google BigQuery and a BI tool that handles incremental data loading automatically. In BigQuery, I have a partitioned table where each partition is represented by a ...
Score of 0
0 answers
249 views
Effective way to track source deleted records in incremental load in Azure Databricks
Scenario :
The source is snowflake and it is in readonly mode.
Implementing full load, saving maximum timestamp in databricks for incremental load.
But in source side apart from record updates, ...
Score of 0
0 answers
44 views
Error code near the 'INSERT' section during incremental ETL insert
USE UsineFlex_DW
GO
DROP VIEW IF EXISTS vue_FaitProduction
GO
CREATE VIEW vue_FaitProduction
AS
SELECT
P.NoProduit,
U.NoUsine,
LP.DateProduction,
M.NoMachine,
LP.Quantite,
LP....
Score of 0
1 answer
739 views
How to implement increment load in pentaho (spoon)
I want to implement increment load in pentaho. I have two tables in my OLTP and I want to apply left join them and drop them as single table in OLAP. OlTP and OLAP are in different database connection ...
Score of -1
2 answers
1344 views
Data Factory succeeds but no data at target
I am running an incremental process for multiple tables where I am using old watermark, new watermark, copy activity, and a stored procedure to update the watermark value. One of my table succeeds ...
Score of 0
0 answers
632 views
How to perform incremental load in snowflake
I have a table T1 in Snowflake that get's truncated and loaded with data weekly. I have to create another table T2 where I should pass all the initial full load from T1 to T2. Then after each week ...
Score of 0
1 answer
359 views
How to load data from github graphql using since like rest API
I have written a pipeline to load issues from GitHub to big query; I want to make it incremental, for example, load only the data from the last run to the present run; I tweaked the pipeline code to ...