Welcome to Software Development on Codidact!

Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.

Sigma‭

Profile Activity Vote Summary All Communities

Atlanta accountant, CPA in progress. Things I'm interested in: everything.

Current active hobbies: koine, HEMA (Meyer tradition), programming (specifically database architecture & management), table-top rpg's (WoD, 3.5/pf).

Things I want to learn (more) about eventually: German, more programming, bicycling, cooking, carpentry, amateur radio (currently general class but no longer active).

What I want to be when I grow up: an engineer.

Posts

See all 8 »

84%

+9 −0

Q&A What is a good modern language to use for a Business Rules project?

This is a rather vague question, but I'm trying to solve a specific problem and I'm inexperienced in most of the potential solutions, so please forgive the inherent ambiguity. I have access to a d...

3 answers · posted 3y ago by Sigma‭ · last activity 1y ago by matthewsnyder‭

Question business-rules

71%

+3 −0

Q&A How to pivot text?

This seems to be looking at the outcome of a bracket in which successive players show an outcome. The table can be easily created by looking at each combination of players and listing them in the t...

posted 4y ago by Sigma‭

Answer

71%

+3 −0

Meta Site scope - draft proposal

Is a question about importing data into Excel on topic (as seen here)? This seems like it would fall under "questions about computers or software that are not connected to software development/engi...

posted 4y ago by Sigma‭

Answer

71%

+3 −0

Q&A How do I return ISO day of week in Redshift?

I have a query summarizing some transaction data that I'd like to summarize by day of week. For my use case, I need to return weekdays formatted according to ISO 8601, so Monday must be the first d...

1 answer · posted 1y ago by Sigma‭ · last activity 1y ago by trichoplax‭

Question sql format redshift

71%

+3 −0

Q&A How do I pass field names containing dashes in dbt source yml file?

Working with dbt version 2 I'm trying to set up source checks but I'm running into an issue where the column names I'm setting tests for have dashes (e.g. my_table.some-field-with-dash). I current...

1 answer · posted 1y ago by Sigma‭ · last activity 1y ago by Sigma‭

Question database-schema dbt

66%

+2 −0

Q&A How do I remove the column options menu from an embedded Look?

I have a Looker table look displayed to users using SSO embedding in an iframe. When displayed to users, the users can access the column options menu via a cog-wheel dropdown. In Admin > Platfo...

0 answers · posted 3y ago by Sigma‭

Question embedding looker

66%

+2 −0

Q&A Redshift int casting from varchar - how to force early evaluation order?

Context: I have a varchar column in a segment event table that contains version numbers. Most of these are formatted nicely as X.Y.Z (major.minor.patch) where X, Y, and Z are integers. However, the...

0 answers · posted 1y ago by Sigma‭

Question sql compiler-errors redshift

60%

+1 −0

Q&A How do I pass field names containing dashes in dbt source yml file?

There may be a better way to handle this but this eventually worked for me. It's necessary to add quote: true below each field name with a dash. E.g.: tables: - name: my_table ...

posted 1y ago by Sigma‭ · edited 1y ago by Sigma‭

Answer

See all 8 »

Reputation		166
Number of top-level posts		5
Number of answers		3
Sum of received votes (up minus down)		26
Number of edits made		1

Earned Abilities

Statistics

Posts
Count		8
Questions		5
Answers		3
Articles		0

Votes cast
Count		13

Flags raised
Count		0