Unanswered Questions in Analytics
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Hello,
Currently SCT doesn't support Redshift as target with Db2 LUW as source database. Could you share what solutions are available for schema conversion for Redshift?
0
answers
0
votes
163
views
asked 4 months agolg...
I used SCT to convert the DDL below from DB2 to Aurora PostGreSQL.
DB2:
CREATE SEQUENCE XX_SCHEMA.SEQ_NO AS DECIMAL(9) START WITH 1 INCREMENT BY 1 MAXVALUE 9999999999 CYCLE;
then I got this DDL as...
0
answers
0
votes
172
views
asked 4 months agolg...
We have a file that we used the default XML crawler to crawl the data for, and it correctly created a table and schema for the data (relevant column shown):
![Correct...
0
answers
0
votes
142
views
asked 4 months agolg...
Hello, i created a zero etl pipeline between a dynamodb table and opensearch index. My table configured like this
```
this.videoTable = new Table(this, 'Videos', {
tableName:...
0
answers
0
votes
258
views
asked 4 months agolg...
[Simba][AthenaJDBC](100131) An error has been thrown from the AWS SDK client. Unable to load AWS credentials from any provider in the chain: [EnvironmentVariableCredentialsProvider: Unable to load AWS...
0
answers
0
votes
426
views
asked 4 months agolg...
Currently, we use AWS OpenSearch with Plugin IK (Chinese) Analysis(https://github.com/medcl/elasticsearch-analysis-ik/tree/master). It has been pre deployed in OpenSearch domain. We want to do some...
0
answers
0
votes
199
views
asked 4 months agolg...
Hi!
When visiting my OpenSearch collection and navigating to Indexes I get a "Failed to fetch".
In console Access to fetch at...
0
answers
0
votes
234
views
asked 4 months agolg...
The query below on current AWS Athena version 3 gives a wrong result for the centroid, which lies way below the polygon (POINT (6.127790214246207 46.2084751184263)). The exact same query in PostGIS...
0
answers
0
votes
422
views
asked 4 months agolg...
When creating a complex field (e.g., in this case outputting a collection of fields to a json format), I managed to break the formatter. Not sure where to log a bug but thought this might be the right...
0
answers
0
votes
64
views
asked 5 months agolg...
I need to load data from my dataframe to BiqQuery table JSON type field.
There is connector that according to documentation supports this feature:...
0
answers
0
votes
56
views
asked 5 months agolg...
I'm working on a project that makes use of Glue Record Matching transforms which, by my best research though AWS docs, is only supported in Glue 2.0 jobs (and additionally, the maximum Glue version I...
0
answers
0
votes
56
views
asked 5 months agolg...
I have a data pipeline built in Redshift Serverless, with some final tables being the result. We are also running a web app that I have set up an Aurora Serverless Postgres DB, to run from. The idea...
0
answers
0
votes
123
views
asked 5 months agolg...