Dremio Create Catalog API

1

Hi Team,

I am facing issue sending an API request using Python Script which makes use of the Catalog api to Create a Virtual Dataset in Dremio Community edition.
The SQL attribute in JSON property for the create request (POST) is getting backslashes() added to them causing the query to break.
Kindly suggest a solution for this:
for eg:
SELECT CAST(CASE WHEN “TestIF1” >= 20 THEN ‘Twenty’ ELSE NULL END AS VARCHAR)

2

@sesh.iyer

Are you trying run a POST SQL API for the below?

CREATE OR RELACE VDS AS SELECT CAST(CASE WHEN “TestIF1” >= 20 THEN ‘Twenty’ ELSE NULL END AS VARCHAR)