Javascript SDK data stream schema to warehouse

The Renta Javascript SDK supports integration with the following data warehouses:

  • Snowflake
  • Google BigQuery
  • Clickhouse

Two tables will be created in your data warehouse after successful integration: events and sessions.

Event table
All events that you have configured using the Javascript SDK will be sent to the data warehouse in real-time.

Session table
Sessions are inserted once a day at 02:00 UTC.

Below you can get acquainted with the structure of the tables and the description of the fields.

Structure of the event table

Field name Type of data Description
dateTime datetime Date and time of the event in UTC
date date Date of the event in UTC
sendAt datetime Date and time when the event was sent from the client side
eventId String Unique Event ID
eventType String Event type
eventName String Event name
properties String Json object that contains custom event attributes
anonymousId String Unique cookie values
userId String UserId number. Contains the value passed to Google Analytics.
groupId String Unique group value (only available for a group type event)
content String Maintance of utm_content
medium String Maintance ofutm_medium
source String Maintance of utm_source
term String Maintance of utm_term
campaign String Maintance of utm_campaign
dataSource String The data source for the request. Initialy, requests from analytics.js they will have the web value, and requests from the mobile SDK will have the app value.
device String Device type: desktop, tablet, mobile, TV. 
deviceBrowser String Browser (for instance, Chrome or Firefox).
deviceBrowserVersion String Browser version.
deviceOperatingSystem String Operating system(for instance, Macintosh or Windows).
deviceOperatingSystemVersion String Operating system version.
deviceIp String IP-adress
country String Country
city String City
region String Region
deviceUserAgent String User Agent
deviceScreenHeight Int Resolution of the user’s screen in pixels by height
deviceScreenWidth Int Resolution of the user’s screen in pixels by width
deviceViewPortHeight Int The size of the viewing area in the browser by height
deviceViewPortWidth Int The size of the viewing area in the browser by width
deviceDocEncoding String Encoding. For instance, UTF-8.
location String URL with additional parameters. For instance:
hostname String


For instance:

path String

Path of the pages URL. 

For instance: /catalog/platya

title String Title of the page.
page String

The full URL path.

For instance:

documentReferrer String If the medium field has the referral value, the path of the traffic source is indicated here, and the host name is contained in the source field.
fbclid String The Facebook Ads click ID that is passed to the URL when the ad is clicked.
gclid String The Google Ads click ID that is passed to the URL when the ad is clicked.
ydclid String The Yandex Direct click ID that is passed to the URL when the ad is clicked.
ga_cookie_id String The unique meaning of Google Analytics cookies
ym_cookie_id String The unique meaning of Yandex Metrika cookies
fbc_cookie_id String The unique meaning of Facebook cookies
fbp_cookie_id String The unique meaning of Facebook cookies
offset String A service parameter of the Javascript SDK. Used to count sessions (the session table is only available in integration with DWH).

Structure of the session table

The Renta Javascript SDK generates sessions based on Google Analytics logic.
You can find more details about the calculation logic in the documentation.

Column name



Session number.
It’s a unique value.


The unique identifier of the Renta Javascript SDK cookie. Sets at the device level.


Array of userId values.


A list of events that are included in the SessionID.


Number of events within the sessionю


Transaction IDs that were reached within the sessionю


The number of transactions that were achieved during the session.


Number of pages viewed.


Number of events.


Time in Unix Timestamp format.


Session start time in UTC. It’s the first dateTime within the session.


The end of the session in UTC. It’s the last hit within the session.


Session start date in UTC.


Session duration in seconds.


Content of utm_content


Content of utm_medium


Content of utm_source


Content of utm_term


Content of utm_campain


Contains Google Click ID if auto-tagging between Google Ads and Google Analytics is enabled.


Device type: desktop, tablet, mobile, TV. 


IP of the device










Browser version


Operating system


Operating system version


The landing page on the site. It’s the page of the first hit.


Domain name. Identifies by landingPage.


Exit page. It’s the last page viewed during the session.


Returns one if there was a failure within the session. The failure is fixed if there was only one hit in the session.


The user’s session number. 

If this is the first session, the field is set to 1.


If this is the first visit, then 1. 

In other cases, an empty value.


Domain name, ignoring utm tags. For instance, if the transition was from, then documentReferral =


The full address of the page from which the transition to the site was made. The logic is similar to documentReferral, but returns the full path of url:Название таблиц

You can specify the name of the tables in the integration configuration: