Summarizing Document Types in Microsoft Academic Graph

CountMagDocTypes.sql

DECLARE @dataVersion string = "mag-2019-03-22";
DECLARE @blobAccount string = "<PLACEHOLDER>";
DECLARE @uriPrefix   string = "wasb://" + @dataVersion + "@" + @blobAccount + "/";
DECLARE @typeCounts string = "/Output/TypeCounts.tsv";

@Papers = Papers(@uriPrefix);

@Types = SELECT
    DocType, COUNT(1) AS cnt
FROM
    @Papers 
GROUP BY
    DocType;

OUTPUT @Types TO @typeCounts
USING Outputters.Tsv(quoting : false);