SQL Query on a Dataset I created in AB
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?
Comments
-
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.