Exporting data to Yandex Cloud

If you use Yandex Cloud and Managed Service for ClickHouse, you can export data from AppMetrica to your cluster. You can use the data, for example, to create your own reports in Yandex DataLens.

Data can be exported in real time: export runs on a regular basis.

This section below describes the steps for configuring export:

Step 1. Check the ClickHouse cluster settings

1. Ensure that your ClickHouse cluster has two or more hosts. This is necessary for replication. If the cluster is with a single host, add one or more hosts.

2. Ensure that the Access from Metrica and AppMetrica option is enabled in the cluster settings.

3. (Optional) To create reports in Yandex DataLens, ensure that the Access from the DataLens option is enabled in the cluster settings.

Step 2. Create a service account and an authorized key

1. Create a service account in the Yandex Cloud console. When creating select a role editor.

   For more information, see Creating a service account in the Yandex Cloud Help.

2. Create an authorized key. After creating, save the secret part of the key, for example, in a text file. You need it to link your service account to AppMetrica.

   For more information, see Creating an authorized key in the Yandex Cloud Help.

Step 3. Start exporting process

1. In the AppMetrica interface, click Data export → Upload to cloud.

2. On the Yandex Cloud data exports page, click Create new export.

3. Link your Yandex Cloud service account To do this, in the Service account field click the Create button. In the window that opens, specify the following:

   Name.

   Enter a name.

   Service account id.

   1. Open your folder in Yandex.Cloud.
   2. Go to the Service accounts page by using the menu on the left.
   3. Click on the service account you created, for example, appmetrica.
   4. In the Overview section, copy the ID value.

   

   Public key id.

   5. Open your folder in Yandex.Cloud.
   6. Go to the Service accounts page by using the menu on the left.
   7. Click on the service account you created, for example, appmetrica.
   8. In the Authorized keys section, copy theID value.

   

   Private key.

   The key that you saved when creating an authorized key.

   Folder ID.

   9. Open the Yandex Cloud console.
   10. Copy the ID of your folder.

   

   Click Create.

4. Select the date period to export. If the Realtime option is enabled, the export process is run regularly.

5. In the field Event fields select the parameters to export.

   For more information about event parameters, see the Logs API available endpoints .

6. In the Cluster field select the cluster to export. It creates a table with exported parameters.

7. Click the Launch export button.

Troubleshooting

See also

• Events
• Logs API

If you didn't find the answer you were looking for, you can use the feedback form to submit your question. Please describe the problem in as much detail as possible. Attach a screenshot if possible.