swahla
Occasional Contributor
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Reading table schema from redshift
Hi rraghvani from the results I get, I assume there is some limit, but now that I looked at it again, it seems 10 characters. If my actual query returns column_name test_attr_boolean row_id data_version created_by created_at updated_at updated_by RecSet.Fields.Item[i].Value returns me only row_id, created_by , created_at , updated_at, updated_by. while not RecSet.EOF: for i in range(0 , RecSet.Fields.Count): var = RecSet.Fields.Item[i].Value dbResult.append(var) counter += 1 RecSet.MoveNext()357Views0likes0CommentsRe: How can I connect to redshift in TestComplete
mikef Any idea on how to set enable_case_sensitive_identifier to true after establishing a connection to redshift in testcomplete. Before executing a query in redshift editor we execute "SET enable_case_sensitive_identifier TO true" then it will consider the table and column names case sensitive. In testcomplete I am not able to do that and hence query always fails to find the tables I pass in queries and I get error "relation not found"547Views0likes1CommentReading table schema from redshift
When i read any values from a table in testcomplete, that works but when I read column names and try to copy them in a list in python, there seems to be a limit of 7 characters and any column names that are longer than that are read as null. How can I solve this problem in test complete.Re: How can I connect to redshift in TestComplete
Marsha_R mikef Thank-you for pointing me in the right direction. I was able to connect after installing ODBC driver and building a connection string for a DSN-less direct connection to redshift mentioned in the shared link. I still have to try through secrets key.784Views0likes2Comments