Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Import Database - External file format missing some FORMAT_OPTIONS - Synapse Serverless Pool #499

Open
anooppaul-official opened this issue Sep 29, 2024 · 0 comments
Assignees
Labels
bug Something isn't working fixed-pending-release Fix in upcoming release
Milestone

Comments

@anooppaul-official
Copy link

anooppaul-official commented Sep 29, 2024

  • SqlPackage or DacFx Version: 162.4.92 SqlPackage
  • .NET Framework (Windows-only) or .NET Core:
  • Environment (local platform and source/target platforms):

Microsoft Visual Studio Community 2022
Version 17.12.0 Preview 2.1
VisualStudio.17.Preview/17.12.0-pre.2.1+35323.107
Microsoft .NET Framework
Version 4.8.09032

Installed Version: Community

SQL Server Data Tools 17.12.19.0
Microsoft SQL Server Data Tools

Steps to Reproduce:

  1. Create external file format as below in Serverless Pool.
CREATE EXTERNAL FILE FORMAT [SynapseCsvFormat] 
WITH ( FORMAT_TYPE = DELIMITEDTEXT, 
       FORMAT_OPTIONS(FIELD_TERMINATOR = ',', STRING_DELIMITER = '''', FIRST_ROW = 2) )
  1. Import or Update the project from database.
  2. In the External Resources folder, search for above file format.
  3. It is missing the FORMAT_OPTIONS - FIRST_ROW = 2

Did this occur in prior versions? If not - which version(s) did it work in? not sure
image
image

Same issue with ADS
image

Dedicated SQL looking good
image
image

(DacFx/SqlPackage/SSMS/Azure Data Studio)

@anooppaul-official anooppaul-official added the bug Something isn't working label Sep 29, 2024
@llali llali added this to the 162.5 milestone Sep 30, 2024
@llali llali self-assigned this Oct 24, 2024
@llali llali added the fixed-pending-release Fix in upcoming release label Oct 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working fixed-pending-release Fix in upcoming release
Projects
None yet
Development

No branches or pull requests

2 participants