Questions tagged with Amazon Redshift
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.
I got the error when write glue dynamic data frame to redshift table .
The code I have used :-
my_conn_op={
"dbtable":"public.xxxx",
...
0
answers
0
votes
155
views
asked 14 days agolg...
I need to union together the results of two queries - we'll call them Query A and Query B. Their outputs have matching column structures and data types, so nothing special should need to be done to...
0
answers
0
votes
88
views
asked 15 days agolg...
I am trying to set-up a Redshift connection using dBeaver CE. I am trying to use the Configuration file option as described in the linked [AWS Doc Using a Configuration...
2
answers
0
votes
263
views
asked 16 days agolg...
**Requirement**: Store geospatial data in Redshift and use Quicksight, allowing users to select various data layers for visualization on a base map.
Question 1: Is Redshift the optimal solution for...
1
answers
0
votes
123
views
asked 18 days agolg...
Hello world!
Is it possible to Enable or Disable Scheduled queries through aws cli (powershell) or python? I know about Query editor v2, but I need to automate this task.
1
answers
0
votes
138
views
asked 18 days agolg...
Hi Minds,
I have an use-case to stream data from Kafka to Redshift. My Kafkas are hosted in Kubernetes in a AWS account(Account B) and not using MSK, how do I stream that to my Redshift Managed...
1
answers
0
votes
109
views
asked 18 days agolg...
I have created Redshift data source from Athena Console using Lambda Connector.
while giving configurations in Lambda connector, we need to give Redshift JDBC URL which is supporting the following...
1
answers
0
votes
169
views
asked 18 days agolg...
Hi All,
Before adding this question i have seen couple of responses for similar use cases but could not figure out the answers as im beginner in SQL coding. Im trying to query the table...
1
answers
0
votes
131
views
asked 18 days agolg...
Hello,
I work as a data engineer and business intelligence specialist for a fintech startup. We've entered into a new agreement with a supplier to provide a technological solution for managing their...
0
answers
0
votes
219
views
asked 19 days agolg...
When I setup column-based access control from Lakeformation permissions on an external catalog table that contains complex data types (e.g. struct/array/map data types), if I query this table using...
0
answers
0
votes
89
views
asked 20 days agolg...
can someone explain me the difference between scoped permission vs when we give permission to normal user
document is little bit tough to understand, if some one can explain the by comparing it with...
1
answers
0
votes
82
views
asked 21 days agolg...
Hi,
I am querying an external partitioned table in redshift spectrum and it throws an error. The data is stored in S3, parquet files and one of the column is 'BINARY'. If i remove the partition column...
0
answers
0
votes
70
views
asked 21 days agolg...