How to enable Javascript

Latest Posts

1
SQL App fetch size - Default Value
What is the default value for SQL App fetch size? Is there a recommendation for tuning this for different size datasets? Thanks,
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 7 mths ago
- 2 replies
- 28
- 1
- Questions & Answers
0
PostgreSQL ODBC and/or JDBC versions
Are there a recommended versions of PostgreSQL ODBC and or JDBC drivers that have been tested with Incorta?
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 31
- Questions & Answers
Re: Is there a way to manually compact a table? Tried a few more things and I ended up having to do a full load on just that one table. I'm now able to preview the data and the mv is working as expected.
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Is there a way to manually compact a table? Thanks for the information. We've had Always Compact turned on for as long as I know. The schema was new (imported from our Dev environment) so after it was imported I ran a full load.…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- Questions & Answers
- Reported - view
0
Is there a way to manually compact a table?
I have a large table (85m rows) that I'm using as a source for a MV (python) and I was having an issue getting any rows returned. I know the mv works because it's working in another environment.…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 3 replies
- 44
- Questions & Answers
- Answered
- Answered
Re: Format of Logging Setting - Server Configurations @Seth Luersen That is exactly what I was looking for, thank you.
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Format of Logging Setting - Server Configurations Hi Ahmed, Thank you for the information. I checked what was currently set on our environments and both of them had the file logging.properties but both of them were just empty files.…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- Questions & Answers
- Reported - view
0
Format of Logging Setting - Server Configurations
I would like to reduce the level of logging on our production system for the analytics and loading services. Actually for everything, services, spark, etc.…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 4 replies
- 83
- Questions & Answers
- Answered
- Answered
Re: IO Error: Cannot run program "chmod": error=24, Too many open files Thank you for the fast response. That link should help. I had increased the limit but I didn't comment out the soft in /etc/security/limits.d/20-nproc.conf.…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- Questions & Answers
- Reported - view
0
IO Error: Cannot run program "chmod": error=24, Too many open files
We've started to get this error on both our development and production environments in the last two weeks. This happens when running a load either from the scheduler or manually selecting Load on a…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 3 replies
- 36
- Questions & Answers
- Answered
- Answered
Re: Log Retention Okay, thank you. I just wanted to make sure there wasn't something already existing before I created it. On a side node I ran into a permission problem with the catalina log file rotation.…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- Questions & Answers
- Reported - view
1
Log Retention
Is there a global setting for log retention for all of the various logs under the analytics and loader services?
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 4 replies
- 98
- 1
- Questions & Answers
Re: Limit for SQL statement size with Incremental Load? Hi @Ahmed Moawad . I first noticed it on 4.5.9 but I was never able to figure out why the selection would work sometimes but not others. We are now on version 4.6.
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- Questions & Answers
- Reported - view
0
Limit for SQL statement size with Incremental Load?
I'm having a strange issue while configuring incremental loads on a table with a large number of fields (280). If I paste the SELECT statement that lists all of the fields individually with the…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 3 replies
- 47
- Questions & Answers
1
HOWTO: Unpivot a table with python
Related to the pivoting of data I also needed to find a good way to unpivot data, specifically from the census data. The data comes with age groups in separate columns: Year, State, City, Under_5,…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 1 reply
- 49
- 1
- Questions & Answers
0
Load Order - Extract and Load Question
Incorta 4.5.9 We have a schema where a table in the schema is loaded from a table in the same schema so I have set the load order for the second table to load after the first table.…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 35
- Questions & Answers
2
HOWTO: Pivot a table with python
I have worked on finding a good way to pivot data and have finally settled on a method that works really well. One benefit of this is if new fields are added it automatically creates the additional…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 85
- 2
- Questions & Answers
0
Uploaded data file via sftp - Not showing up in list unless refreshed by Super User
We are working on an automated system for uploading data files and the upload is working correctly. The problem we are having is that the any new files won't show up under Data Files in the…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 1 reply
- 28
- Questions & Answers
Re: Using a Business View to Update a Historical Table Hi Dan Thanks for the reply. Yes, that is essentially what I'm doing now and it's working. My question is more of if there is a better way or a reason I shouldn't do that.…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- Questions & Answers
- Reported - view
0
Using a Business View to Update a Historical Table
How bad of an idea is it to use a business schema as a source for a historical table in schema? We have a requirement to keep a snapshot of customer data on a monthly basis.…
- Ryan Sather
- Gate City Bank
- Ryan_Sather
- 1 yr ago
- 3 replies
- 45
- Questions & Answers

Back to top

Ryan Sather

Ryan_Sather

Gate City Bank

Fargo, ND

21
9
0

Follow