SQL Query on a Dataset I created in AB

Alan.P.39
Alan.P.39 Posts: 19 Analytics Builder Transition

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.