Advice and answers from the Openbridge Team

Search results for:R

How to fix 'Host key verification failed' SSH Error

-R {ssh.server.ip.address} ssh-keygen -R {ssh.server.ip.address} -f {/path/to/known_hosts} $ ssh-keygen… sed -i '/1.2.3.4/d' /home/ec2-user/.ssh/known_hosts Another option is to user ssh-keygen with the -R… If your remote hostname is server.openbridge.com ssh-keygen -R {server.openbridge.com} $ ssh-keygen

How To Easily Extract Data With Headers From Amazon Redshift

We created a service that wraps the Redshift UNLOAD command with some extra capabilities. This article explains how to run it… How To Run… Runtime parameters

How To Query Amazon Multi-market Accounts With Data Duplication

Standardizing `posted_date` CASE WHEN REGEXP_CONTAINS(T.posted_date, r'^\d{2}\.\d{2}\… standardized_posted_date, -- Standardizing `posted_date_time` CASE WHEN REGEXP_CONTAINS(T.posted_date_time, r'

How to Connect Tableau to Redshift

A Guide to create first Tableau visualization with data in Amazon Redshift… Your first visual in Tableau with the data from Redshift is ready! Enjoy the view!… How to connect Tableau to Amazon Redshift

How To Test Amazon Advertising Reporting Data

The Amazon Advertising reporting interface has different data than the API. Why?… Run a Reporting data export for Sponsored Products in the Amazon Advertising Reporting UI to do so… Configure and run a report export

Analytics-Ready: Freedom to Connect Your Data Tools

Delivering flexible, code-free analytics-ready data pipelines… Understanding the rapid rate of innovation is why we focus on open, standards-based architectures… data in Amazon Redshift, Amazon Redshift Spectrum, Google BigQuery, Azure Data Lake, Snowflake, or Amazon

How To Setup Amazon Redshift Spectrum Data Destination

This is the Amazon Web Service region that wants Amazon Redshift Spectrum configured… The IAM Role ARN allows us to call the AWS Redshift Spectrum services on your behalf… It will look like this arn:aws:iam::1223131231231:role/your-role-name

Product Development Requests

Framework for product development roadmaps… Before beta releases, Openbridge releases pilots of services… Requesting Product Development

How To Submit A Support Request

First, please limit each request to one support item rather than a laundry list of questions and requests… When an original request asking for X shifts to questions or requests for Y or Z, responses will slow… We will generally respond within 24 hours of receiving a ticket

Configuring Your Amazon Redshift Data Warehouse Environment

Configuring Redshift instance schemas, users and permissions… Note: If you need more help, please refer to the official Amazon Redshift documentation for detailed… To create a Redshift account for Openbridge, you must be an admin Redshift user with the correct permissions