SQL Query on a Dataset I created in AB

Alan.P.39

I'm trying to find my footing in AB… and followed the course tutorial on including the full schemaName.tableName_version_number in the query. Does this mean I can only create a SQL query on the tables listed in the schema? Can I not create queries that references a customized dataset that I build or that has been shared in AB? How might I write a SQL query that references the Enrollment Details [Template] dataset for example?

And does including the version_number in the SQL query mean I will need to manually update all the queries as the versions are updated?

Ian.P.710

Hi Alan currently you can only reference the default Brightspace datasets in the SQL. As such you would need to build the Enrollment Details from the base datasets as a cte in your SQL. Regarding the version number this is automatically updated by d2l in custom SQL so 9_10_3 will change to 9_11_3 as an example automatically.
However you might need to manually change when a major version is available such as in the December release.