Hello all, I have a quick question that you might ...
# gooddata-platform
p
Hello all, I have a quick question that you might be able to help with: Is it possible to import from a data source (Postgres) only selected dates e.g. only dates from the last year? Currently we work around this by cloning the relevant tables on the database itself, but wondered if there might be a way to do this on import.
m
Hi Paul, I presume you are using GoodData Platform and not GoodData Cloud. In that case, have you considered loading the data from a view built with the desired date constraint? Another alternative is the usage of incremental load mode, this will allow you to update the dataset in which only new or modified records are uploaded to the project from a specified date. Note that, if the target record is modified in the incoming data or if there is no target record, the incoming data is written to the project
p
Hi Moises, thank you for this information. I'll take a look as these options might just do what we want. Thanks again
1