Relative Content

Tag Archive for azure-pipelinesazure-synapseazure-synapse-pipeline

Preserving the data type in a different file format

I’m currently looking to import some data from SQL Server, on the SQL Server it has its data types correctly set in the schema. Unfortunately, I am unable to use parquet or ORC files for what I am doing so I want to preserve the data type in a different file format. I have recently tried JSON, which seems to work when I click import schema on the mapping, but I want to apply the logic to a ingest pipeline loop that pulls in around 20 different tables, but we have no idea how to do it.