Run a query with SQL Data Explorer • Analytics • Unity Docs
Analytics
Analytics
このページは選択した言語では使用できません。
Run a query with SQL Data Explorer
Create and execute SQL queries on your Analytics data using SQL Data Explorer.
読み終わるまでの所要時間 2 分最終更新 2日前
SQL is a programming language used to communicate with databases. A basic understanding of writing SQL queries is required to use SQL Data Explorer. See our collection of "recipes" in the SQL cookbook Data Explorer Queries. Queries are run against Snowflake, so use the Snowflake SQL dialect. Note that non-
SELECT
statements and
$SYSTEM
commands are limited in functionality.When you first open SQL Data Explorer, a query that counts the number of distinct users who have played your game in the last seven days is shown. You can try this query out or delete it and build your own.The Glossary panel provides a list of parameters you can use in your query. Use the copy button to copy parameters to the clipboard. The glossary terms are pulled from two sources: the database column names (such as
EVENT_DATE
) and custom parameters parsed from the event json (see Snowflake documentation on how to query JSON data). You can define custom parameters depending on the events you send. Some parameters are fields specific to Snowflake, which can change the syntax in the SQL. A list of available tables and their columns can also be found on the SQL Data Explorer queryable tables page.Database column names are more performant for querying than the parameters parsed from JSON and should be preferred when possible.If a parameter is represented by a column (such as
USER_COUNTRY
), the query uses it as:
USER_COUNTRY
If a parameter comes from the event itself, named
missionName
in this example, it's accessed via:
EVENT_JSON:missionName::STRING
For more information about building custom events, see the create a custom event tutorial.After running a query, you need to set up the chart. You can toggle between a bar chart, line graph, area graph, pie chart, and stacked bar chart. Currently, two Y axes and one X axis are supported.
ヒント
To rename an axis label, use the
as
expression in your SQL query.
If you run a query without any data ordering, it's possible that your charts won't be an accurate representation of your data as it's not sorted. A warning will be displayed in this instance and it's recommended to order your query through the use of an
order by
keyword.Under your chart is a table of results, showing the columns and result of your query.Use reports to save your queries. The Reports selector provides a list of all saved queries so you can reload and use them later.Use the Environments selector to switch between Unity Environments.For information on all the tables and columns available, see the SQL Data Explorer queryable tables page.