SQL 4 CDS 10.4 adds CSV imports and live query results
Diesen Beitrag auf Deutsch lesen
SQL 4 CDS 10.4 can import CSV data into Dataverse, show results during execution, display text output and expose more metadata.
TL;DR
SQL 4 CDS 10.4 adds OPENROWSET CSV imports for Dataverse, including multiple files, file metadata and encoding options. Queries can populate the results grid while running, results can display as text, five maths functions are supported, and statecode or statuscode metadata now exposes additional columns.
Original by Mark Carrington, on Mark Carrington. Read the original
This is our own summary, not a republication or full translation.
Why it matters
- Makers: Use OPENROWSET with FIRSTROW, file format settings and CODEPAGE when loading CSV data into Dataverse, especially when headers or special characters need handling.
- BI/Data teams: Use wildcard imports plus filename or filepath metadata for multi-file loads, and inspect live query output or text results while troubleshooting longer queries.
- Makers: Check the expanded statecode and statuscode metadata when queries need default status, related state or custom transition details.
Frequently asked questions
How can SQL 4 CDS 10.4 import a CSV file into Dataverse?
SQL 4 CDS 10.4 uses OPENROWSET with FORMAT='CSV' in a SELECT statement, which can feed INSERT, UPDATE or DELETE operations.
Which maths functions does SQL 4 CDS 10.4 support?
The release adds ABS, SIGN, CEILING, FLOOR and ROUND for SQL 4 CDS queries.
How does SQL 4 CDS 10.4 expose statecode and statuscode metadata?
The metadata.optionsetvalue table adds defaultstatus, state, invariantname and transitiondata information for relevant statecode and statuscode values.