Do targets built with the SDK handle schema change...
# singer-targetss
Stéphane Burwash
11/07/2022, 8:38 PMDo targets built with the SDK handle schema changes gracefully out of the box? Or would this be something that needs to be coded?
a
aaronsteers
11/07/2022, 8:53 PMIn the current iteration, I think there is still some work to do. However, once the deliverables in this milestone are achieved, I think the capability will be fully baked-in.
aaronsteers
11/07/2022, 8:55 PMThe overall philosophy is that tap developers should declare certain aspects of the target system, such as whether the target suports merge upserts, temp tables, altering existing columns, etc... and the SDK would pick a default strategy based on those inputs.
s
Stéphane Burwash
11/07/2022, 9:05 PMThat would definitely be amazing 😄
Stéphane Burwash
11/15/2022, 7:07 PM@aaronsteers would you have any suggestions on how to implement support for schema changes in a target?
a
aaronsteers
11/15/2022, 7:08 PMSure. Is this for a SQL target, and does it (or can it) use the SDK?
s
Stéphane Burwash
11/15/2022, 7:11 PMSDK target (trying to adapt Alex's Loader to include schema definition in the tap).
Here is the current PR, if you're interested https://github.com/z3z1ma/target-bigquery/pull/1/files