Sql-docs: Missing column information

[sidesw1pe]

I can see the following columns, which are not described in this article, when I select from sys.external_data_sources:

1. connection_options
2. pushdown

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: fd8614c9-679c-a0d9-719e-9cb63e5d81bb
• Version Independent ID: 3193d7a4-387b-b9bb-60b1-f5c066fd1358
• Content: sys.external_data_sources (Transact-SQL) - SQL Server
• Content Source: docs/relational-databases/system-catalog-views/sys-external-data-sources-transact-sql.md
• Product: sql
• Technology: system-objects
• GitHub Login: @stevestein
• Microsoft Alias: sstein

[WilliamAntonRohm]

@sidesw1pe -- thank you for your feedback.

@stevestein -- please look into this issue #4170.

[rothja]

Apologies for the delayed response. @CarlRabeler Could you please look into this issue? Thank you! #reassign:CarlRabeler

[CarlRabeler]

@pmasl Pedro, could you please look at this issue re: missing columns? Thanks, Carl

[pmasl]

reassign:uc-msft

[pmasl]

assign:CarlRabeler

[pmasl]

assign:uc-msft who owns this area. Confirmed the new SQL 2019 columns were missed.

[PRMerger10]

uc-msft is already assigned.

[CarlRabeler]

reassign:uc-msft

[rothja]

@uc-msft Could you add descriptions for these columns here and I can help get it into the docs. #assign:rothja

[pmasl]

Also @mihaelablendea in case she has context

[rothja]

@mihaelablendea @uc-msft Please take a look at this older git issue. @sidesw1pe has pointed out that the table sys.external_data_sources does not have documentation for two columns:

1. connection_options
2. pushdown

I verified these columns exist on SQL Server 2019:

If you can provide some descriptions, I can help add them to the article.

Mihaela, I'm adding you to the issue along with UC and me. #assign:mihaelablendea

[rothja]

@mihaelablendea @uc-msft Let me know if you have a chance to take a look at this. Thank you!

[MikeRayMSFT]

Tracking in User Story 1799704: PolyBase | Git Issue - Describe new columns in sys.external_data_sources