Function and Feature of SQL which we can use to manipulate data:
- Filter rows and columns in a dataset.
- Rename data fields and convert between data types.
- Calculate derived data fields.
- Manipulate string values.
- Group and aggregate data.
We can use Synapse SQL Serverless Pool to run SQL statements that transform data and persist the result as a file in Data Lake for further processing and querying.
We can create an external table in a dedicated SQL or serverless pool to persist the result of the query in an external table, which stores its data in a file in the data lake.