Virtual DataSets VDS api?

1

Good morning everyone,

Is there a way to see whether a virtual dataset is present? I am trying to create a virtual dataset using rest api’s but before doing that i want to check if a viatual dataset already exists by that name. I am not sure if its worth checking it or if there is a way to do that.

Can you please help me with this? I already verified that catalog/by path is only applicable to PDS and I cant really use it for VDS.

Thank you
Raavi

2

@sraavi - You can try a couple of things to do this:

  • While creating the VDS using API you can use the SQL syntax "create or replace VDS as <VDS_Defination>

https://docs.dremio.com/sql-reference/sql-commands/datasets/#replacing-virtual-datasets

  • You can run the below SQL using API to check if VDS is present or not.
select * from information_schema.views where table_schema = '<schema_name>' AND table_name = '<VDS_Name'>
1 Like