Does anyone know if you can load a table function using tap-mssql? Are parameters supported? I see that views show up when running
meltano select tap-mssql --list --all
, but functions aren't.
e
Edgar Ramírez (Arch.dev)
06/14/2024, 10:03 PM
I'm not familiar with table functions in mssql. Can you say more about your use case?
d
Dev Lunyx
06/17/2024, 12:58 PM
We have several data sources that are exposed by a 3rd party vendor that uses table functions. Some of them also have additional parameters to partition the data.
Dev Lunyx
06/17/2024, 1:00 PM
We don't have the underlying table that these refer to in some cases because it can be dynamically regenerated with a different Guid, or it can be a join to multiple tables