how are my non-evans?

Morning

Opiniins?

@EvanCarroll We are.

Anybody have any experience with snowflake? Our datawarehousing team is going with that.

One of the questions they have is for example if they can integrate our timeseries data currently stored in InfluxDB (or possibly replace influxdb, but that seems like a bad idea to me)

I'm not sure what they want with timeseries in their datawarehouse anyway, at least not the raw data, and neither do they if I ask further details

but just any general experience with the platform would be appreciated

cc @mustaccio (and COTW but he's no longer pingable here)

morning

@TomV-trytopanswers.xyz no, sorry.

Morning

@PaulWhite9 A horse fixed it. Now we have currency

why.gif

laughing_tears.gif

Rick's comment greatly helped me to understand at least the premise of the issue. Still not sure what exactly happened or needs resolving.

@AndriyM I think the question is more about accounting rules than the technical implementation

I don't know if in India they are supposed to use the conversion rate from the time of sales or the time of payment

In Belgium we have a concept of exchange rate revaluations where you basically revalue your outstanding payments (in or out) using current exchange rates, but you still pay or receive the amount of dollars that was on the invoice originally. The debt account which is valued in euro gets adjusted to how much that is in your accounting currency.

I would expect that to be more or less similar in any case where you incur a debt in a foreign currency. You are expected to repay it in the currency the debt was agreed on. Whatever happens to exchange rates afterwards is an internal bookkeeping issue

@TomV-trytopanswers.xyz Ha. Oh well. The question's headed for deletion and the tag will go with it.

@TomV-trytopanswers.xyz I don't know anything about Snowflake

@TomV-trytopanswers.xyz That's actually what I thought too. The question appears to be what currency to save the invoice amount in or something like that. Indeed looks like it depends on business requirements, be at specifically accounting or not, so it's off-topic anyway.

SSIS question - I have a lookup component in a data flow task where I want to take the no match output and add the same default value to every row. The catch is I need to get the default value from a table and I can't seem to find a non-hacky way to accomplish this. If I could use a derived column to perform a query or a lookup component with no mapped columns it would fine but I don't think I can do either of those things.

I could just add a derived column with a static value to use for column mapping in the lookup component but that seems like a pretty terrible solution

Of course, what most people call "pretty terrible" SSIS calls "elegant and idiomatic" so...

> Beside above remarks by @ybercube, ...

heh, ypercube -> ybercube -> cybercube ;)

@PaulWhite9 how very welcoming ;)

@MikeTheLiar Is the "default" value being put in constant for the entire load? Load it into a variable at the start?

I ended up adding the derived column constant value and just doing the lookup on that

select ValueICareAbout, 1 'MergeKey' from Table and an associated derived column

@ypercubeᵀᴹ yphercube?

cyborgube

resistance is futile

tf?

dba.stackexchange.com/review/low-quality-posts/147401

"not an answer" is gone??

i am le confuse

Perhaps there's something on Meta about this, unless it's a bug

it's curious

like a cat

Depends on the "answer", I guess. Next one in the queue:

@mustaccio that was before it in the queue for me, as i'm sure you saw :p

How would I see your queue?

@mustaccio I'm not sure what Peter meant but I think you can get it from the history by looking who has reviewed which items and in what order.

@mustaccio you wouldn't, but you would have seen the comment i left on the post; which you also capture in your screenshot ¯\_(ツ)_/¯

^^^ That too :)

:p

I only read my own comments

weird flex but ok

😂

Anyway, I think the range of LQ delete options is limited for older posts.

@mustaccio I think you are right. It even says there, 'This answer has been on the site for quite a while now; it probably won't benefit from commentary.' Strange I didn't notice that immediately