0

Per the documentation on Analytical store.

What is Azure Cosmos DB Analytical Store?

“The first non-null occurrence defines the column data type. Any document not following the first non-null datatype won't be represented in analytical store.”

I want to confirm my DateTime columns are interpreted as DateTime and not stored as string.

How can I view the Well-defined schema representation?

Xavier John
  • 8,474
  • 3
  • 37
  • 51

1 Answers1

0

There are two solutions:

  1. SQL Serverless:

a) Create a view say MyView that gets the data.

b) Run the following against that view.

sp_describe_first_result_set @tsql = N'select * from MyView where 1=0'
  1. Spark: df.printSchema
Xavier John
  • 8,474
  • 3
  • 37
  • 51