You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.

Data Warehouse Technology

Agile Data Warehousing Service is based on the Vertica database. Each node in an Data Warehouse cluster runs an instance of the Vertica database.

Data Warehouse supports the SQL:99 standard with several Vertica-specific extensions.

For more information on the limitations against the SQL:99 standard or the Vertica documentation, see Limitations and Differences in Data Warehouse from Other RDBMS.
For additional details, see the Vertica documentation.
You need GoodData’s Data Warehouse JDBC Driver to connect to Data Warehouse. The Vertica JDBC driver cannot be used to connect to Data Warehouse. See Download the JDBC Driver.

Data Warehouse Architecture

Data Warehouse Logical and Physical Model

Manage cookies

GoodData categorizes three types of cookies according to the area they address: Necessary, Website related, and Communications related.

Necessary(always on)

These cookies are strictly necessary to provide you with services available through our Websites, to analyze traffic and to use some of its features, such as access to secure areas.

Website and content experience

These cookies provide us with information on how our websites are being used, to help us improve the quality and relevance of content we place on them. Additionally, they also allow us to show you embedded videos and remember your preferences and actions, so that the websites do not bother you with the same request repeatedly (e.g. filling a form to download a PDF file and provide feedback about such actions to our affiliated entities).

Communications

These cookies remember what content you visited on our websites, to help us share with you only relevant marketing content that addresses your needs and interests. Our marketing content (i.e. banners) will appear on other websites.

Read cookie policy