Searching Complex JSON in SQL Server

preview_player
Показать описание
Today's video looks at a method for searching across rows of complex JSON data.

Related blog post with more examples:

Follow me on Twitter:
  1. Bert Wagner
  2. SQL Server
  3. SQL
  4. SQL training
  5. json
  6. openjson
Рекомендации по теме
Searching Complex JSON 0:05:08

Searching Complex JSON in SQL Server

How to import 0:21:19

How to import nested JSON object (JSON data file) in Microsoft SQL Server

Parse JSON string 0:10:36

Parse JSON string with nested elements in SQL Server

Read JSON data 0:03:59

Read JSON data from a table and parse it to rows and columns

Array : How 0:01:14

Array : How to parse nested JSON array using SQL Server

SQL : Select 0:01:08

SQL : Select row where nested JSON array contains certain value

How to filter/select 0:05:50

How to filter/select json data. How to use json column in where clause. #postgresql #sql

Pyspark Scenarios 21 0:11:59

Pyspark Scenarios 21 : Dynamically processing complex json file in pyspark #complexjson #databricks

PowerShell Meets DuckDB 1:08:19

PowerShell Meets DuckDB Integrate, Query, and Analyze Data Seamlessly

Databases: SQL Server 0:03:25

Databases: SQL Server 2016 Nested JSON Array (2 Solutions!!)

Search Filter rows 0:00:54

Search Filter rows based on JSON column data using sql server query #json

SQL : How 0:01:27

SQL : How to insert nested json data in mysql table?

SQL Interview Questions 0:00:59

SQL Interview Questions Search Functionality JSON Data SQL Query #sqlinterviewquestionsandanswers

Deep dive: Using 0:43:08

Deep dive: Using JSON with SQL Server

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Using OPENJSON and 0:08:32

Using OPENJSON and a CROSS APPLY JOIN to Separate Arrays of JSON Object Types

Querying and Updating 0:05:41

Querying and Updating JSON Data in a SQL Server Table

Parse / Process 0:18:59

Parse / Process Nested JSON File using Databricks

Loading Data into 0:10:10

Loading Data into BigQuery | Query Nested Json Data with SQL

Python - Accessing 0:24:48

Python - Accessing Nested Dictionary Keys

SQL : Create 0:01:24

SQL : Create nested json from sql query postgres 9.4

Read JSON Data 0:00:47

Read JSON Data in SQL SERVER | Part 13 #database

SQL : How 0:01:02

SQL : How to query nested arrays in a postgres json column?

SQL : Return 0:01:13

SQL : Return SQL Server database query with nested Json

Комментарии
Автор

Hey, Bert! Thanks a lot!!! That one was super-useful! Right now we’re using ugly stored procedures with calls to built-in Python to parse JSON. Definitely worth trying your clever recursive cte solution on our use-case. Thanks again!

DodovNes
Автор

Hey Thanks Bert!! I'm gonna use this and will share feedback. Just want to know how code will behave when some of Array doesnt have value in it.. For E.g. can we get any array as [4, null, 5, 6] Just like mentioned in Property9 and do we get it property[1] as null??
Anyways I'm gonna test it. I want to make a proper tabular data out of nested JSON to push into a table. from Key-Value pair as a DW repository

pankajtodkar
Автор

Thank you! One question: Why not to store the JSON documents in this key/value pair tables in the first place then?

AttaKru
Автор

I would like to see query plans over date ranges (or... in general interval ranges) dealing with JSON indexes.... XML indexes fail a lot... what do you think?

stefanotorelli
Автор

is there a video on extracting out all values and pairs, even deeply nested into a SQL table. with a pivot so all elements are in columns for that row.

Chris-byeh